我在mysql里制定了一个任务如下
mysql> create event DelEvent
-> ON SCHEDULE EVERY 5 minute
-> starts '2010-06-24 15:36:00'
-> do
-> delete from table where TO_DAYS(NOW()) - TO_DAYS(collectdate)>=750;
Query OK, 0 rows affected (0.00 sec)
但是时间到了后根本不执行,请问是为什么啊
事件任务已打开
mysql> show variables like '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)
mysql> create event DelEvent
-> ON SCHEDULE EVERY 5 minute
-> starts '2010-06-24 15:36:00'
-> do
-> delete from table where TO_DAYS(NOW()) - TO_DAYS(collectdate)>=750;
Query OK, 0 rows affected (0.00 sec)
但是时间到了后根本不执行,请问是为什么啊
事件任务已打开
mysql> show variables like '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)
mysql> 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 |
+-------+----------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
| itm22 | DelEvent | root@localhost | SYSTEM | RECURRING | NULL | 5 | MINUTE | 2010-06-24 16:16:00 | NULL | ENABLED | 0 | latin1 | latin1_swedish_ci | latin1_swedish_ci |
+-------+----------+----------------+-----------+-----------+------------+----------------+----------------+---------------------+------+---------+------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)