mysql> delimiter ||
mysql> create procedure sp_test_sleep()
-> sql security invoker
-> begin
-> select 'sleep start';
-> select sleep(5);
-> select 'sleep end';
-> end||
Query OK, 0 rows affected (0.03 sec)
mysql> delimiter ;
mysql> call sp_test_sleep();
+-------------+
| sleep start |
+-------------+
| sleep start |
+-------------+
1 row in set (0.00 sec)
+----------+
| sleep(5) |
+----------+
| 0 |
+----------+
1 row in set (5.00 sec)
+-----------+
| sleep end |
+-----------+
| sleep end |
+-----------+
1 row in set (5.00 sec)
Query OK, 0 rows affected (5.00 sec)
mysql>
阅读(623) | 评论(0) | 转发(0) |