站长论坛

标题: Mysql以一定的时间间隔自动去运行这个脚本文件 [打印本页]

作者: superadmin 时间: 2009-3-5 13:43
标题: Mysql以一定的时间间隔自动去运行这个脚本文件
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>

欢迎光临站长论坛 (https://tzlink.com/bbs/)