delimiter //
drop event if exists myevent//
create event myevent
on schedule
AT CURRENT_TIMESTAMP + INTERVAL 2 MINUTE
DO
CALL shopprocedure();
delimiter ;怎么调用不到存储过程?
drop event if exists myevent//
create event myevent
on schedule
AT CURRENT_TIMESTAMP + INTERVAL 2 MINUTE
DO
CALL shopprocedure();
delimiter ;怎么调用不到存储过程?
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)set global event_scheduler=on;
http://topic.csdn.net/u/20091020/22/c51bb709-6dbc-4fd1-b874-077714ed547e.html