1
2
3
4
5
6
7
|
mysql>selectsleep(1);
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 rowinset(1.00 sec)
|
1
2
3
4
5
6
7
|
mysql>selectnamefromanimalswherename='tiger';
+-------+
|name |
+-------+
| tiger |
+-------+
1 rowinset(0.00 sec)
|
1
2
3
4
5
6
7
|
mysql>selectsleep(1),namefromanimalswherename='tiger';
+----------+-------+
| sleep(1) |name |
+----------+-------+
| 0 | tiger |
+----------+-------+
1 rowinset(1.00 sec)
|
1
2
|
mysql>selectnamefromanimalswherename='pig';
Emptyset(0.00 sec)
|
1
2
|
mysql>selectsleep(1),namefromanimalswherename='pig';
Emptyset(0.00 sec)
|
1
2
3
4
5
6
7
8
9
|
mysql>selectnamefromanimalswherenamelike'%ger';
+-------+
|name |
+-------+
| ger |
| iger |
| tiger |
+-------+
3rowsinset(0.00 sec)
|
1
2
3
4
5
6
7
8
9
|
mysql>selectsleep(1),namefromanimalswherenamelike'%ger';
+----------+-------+
| sleep(1) |name |
+----------+-------+
| 0 | ger |
| 0 | iger |
| 0 | tiger |
+----------+-------+
3rowsinset(3.01 sec)
|