MYSQL ʼþµ÷¶ÈµÄÀý×Ó

1.SET GLOBAL event_scheduler = ON;
2.show processlist;
3.´´½¨Ò»¸ö±í test Ö÷Òª×ֶΠno,name,sex,age
4.¶Ô¸Ã±í²åÈ缸ÌõÊý¾Ý
5.´´½¨´æ´¢¹ý³Ìadd_age
drop procedure if exists add_age;
delimiter|
create procedure add_age()
begin
  start transaction;
  update eventtest set age = age +1;
  commit;
end;
|delimiter;
6.¸øµ±Ç°Óû§¸³Óè´´½¨eventµÄȨÏÞ(»òÕß»»ÓÐȨÏÞµÄÓû§?)
7.´´½¨event
create event if not exists add_age_one_minutes
on schedule every 1 minute
on completion preserve
do
call add_age();
(X¸Ãeventÿ·ÖÖÓÖ´ÐÐÒ»´Î)