SELECT SYSDATE(), SLEEP(2), SYSDATE(); : SLEEP : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » SLEEP »

SELECT SYSDATE(), SLEEP(2), SYSDATE();


mysql>
mysql> SELECT SYSDATE(), SLEEP(2), SYSDATE();
+---------------------+----------+---------------------+
| SYSDATE()           | SLEEP(2) | SYSDATE()           |
+---------------------+----------+---------------------+
| 2007-07-22 19:46:15 |        0 | 2007-07-22 19:46:17 |
+---------------------+----------+---------------------+
1 row in set (2.02 sec)

mysql>