標籤:
1、檢查計劃任務是否開啟mysql> set global event_scheduler=off;Query OK, 0 rows affectedmysql> select @@event_scheduler;+-------------------+| @@event_scheduler |+-------------------+| OFF |+-------------------+1 row in setmysql> set global event_scheduler=on;Query OK, 0 rows affectedmysql> select @@event_scheduler;+-------------------+| @@event_scheduler |+-------------------+| ON |+-------------------+1 row in set2、建立計劃任務mysql> show events;Empty setmysql> create event event_insert on schedule every 1 second enable do insert into stu (name,age,updatetime) values(‘Caroline‘,5,now());Query OK, 0 rows affectedmysql> show events;+--------+--------------+---------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+| Db | Name | Definer | Time zone | Type | Execute at | Interval value | Interval field | Starts | Ends | Status | Originator | character_set_client | collation_connection | Database Collation |+--------+--------------+---------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+| testdb | event_insert | [email protected]% | SYSTEM | RECURRING | NULL | 1 | SECOND | 2015-03-25 19:57:41 | NULL | ENABLED | 0 | utf8 | utf8_general_ci | utf8_general_ci |+--------+--------------+---------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+1 row in set3、定時添加記錄mysql> delete from stu;Query OK, 6 rows affectedmysql> select * from stu;+-----+----------+-----+---------------------+| Id | Name | Age | updatetime |+-----+----------+-----+---------------------+| 232 | Caroline | 5 | 2015-03-25 19:58:57 || 233 | Caroline | 5 | 2015-03-25 19:58:58 |+-----+----------+-----+---------------------+2 rows in set4、修改計劃任務mysql> alter event event_insert on schedule every 1 second disable;Query OK, 0 rows affected
Mysql計劃任務