mysql event scheduleÎÊÌâ

ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏÂ

delimiter |
create event myevent  on schedule every  2 second
starts current_timestamp
ends  current_timestamp+interval 10 second
do
begin
if v_studentName like 'Íô%' then
update manager set  v_teacherID=v_teacherID+1;
end if;
end;|
delimiter ;
½¨Á¢¶¨Ê±Æ÷ºóÏÔʾQuery OK, 0 rows affected (0.01 sec)
µ«ÊDzéѯ±íºó·¢ÏÖv_studentName like 'Íô%'µÄ v_teacherIDûÓбä,
ÓÐʲôÎÊÌâô?

---

SET GLOBAL event_scheduler = 1;

---

ºÇºÇ
ÄãµÄϵͳ±äÁ¿ event_scheduler  ÓÐûÓм¤»î£¿
SET GLOBAL event_scheduler = ON;

---

Ò»¸öeventʾÀý£º

SQL code:
¼ì²éevent¹¦ÄÜ£º
mysql> show variables like '%sche%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.01 sec)

Æô¶¯event¹¦ÄÜ£º
mysql> set global event_scheduler =1;
Query OK, 0 rows affected (0.00 sec)

È·¶¨ÆðÓÃevent¹¦Äܺó£¬Ö´ÐÐÏÂÃæµÄ½¨Á¢event£º(Ö»update²»insertŶ£©
delimiter //
create EVENT my_stat_event
ON SCHEDULE
EVERY 24 HOUR
STARTS concat(date_format(now(),'%Y-%m-%d'),' 23:00:00')
on completion preserve ENABLE
do
b