????Mysql??event schedule???????????????mysql???????????????????????????
????create event test1
????on schedule every 1 day
????starts '2007-09-01 12:00:00'
????on completion not preserve
????do insert into yyy values('hhh'??'uuu');
??????
????create event test
????on schedule at '2007-09-01 12:00:00' + interval 1 day
????on completion not preserve
????do insert into yyy values('hhh'??'uuu')
????????:??2007??9??1???????????yyy??12:00:00???в???????????????????.
???????????????????????event_scheduler???????????
????set global event_scheduler=1;
??????
????set global event_scheduler=on;
?????????????????????????????????--event_scheduler=1.????:
????mysqld...--event_scheduler=1
??????????????????mysql.ini????mysql.cnf?????
????event_scheduler=1
?????????????????????????????????????????sql:
????show variables like 'event-scheduler';
????????
????select @@event_scheduler;
????????show processlist;
???????????????(create event)

 

create event [if not exists] event_name
on schedule
[on completion[not] preserve]
[enable|disable]
[comment 'comment']
do sql_statement;
schedule:
at timestamp [+interval interval]
|every interval [starts timestamp][ends timestamp]
interval:
quantity{year|quarter|month|day|hour|minute|
week|second|year_month|day_hour|day_minute|
day_second|hour_minute|hour_second|minute_second}