????1)???????????????????????????????????????????:
????use test
????create table aaa(timeline timestamp);
????create event e_test_insert
????on schedule every 1 second
????do insert into test.aaa values(current_timestamp);
???????????????в??????:
????mysql>select * from test.aaa;
????????????????????????
????2)5??????aaa??:
????create event e_test
????on schedule at current_timestamp+interval 5 day
????do truncate table test.aaa;
????3)2007??7??20??12???????aaa??:
????create event e_test
????on schedule at timestamp '2007-07-20 12:00:00'
????do truncate table test.aaa;
????4)???????aaa??:---??????????????????????и?event
????create event e_test
????on schedule every 1 day
????do truncate table test.aaa;
????5)5????????????aaa??:
????create event e_test
????on schedule every 1 day
????starts current_timestamp +interval 5 day
????do truncate table test.aaa;
????6)???????aaa???5????????:
????create event e_test
????on schedule every 1 day
????ends current_timestamp + interval 5 day
????do truncate table test.aaa;
????7)5????????????aaa???????o??????
????create event e_test
????on schedule every 1 day
????starts current_timestamp + interval 5 day
????ends current_timestamp + interval 1 month
????do truncate table test.aaa;
??????????????(alter event)
????alter event event_name
????[on schedule schedule]
????[rename to new_event_name]
????[on completion [not] preserve]
????[comment 'comment']
????[enable|disable]
????[do sql_statement]
????1)?????????
????alter event e_test disable
????2)???????
????alter event e_test enable
????3)????????aaa???????5????????
????alter event e_test
????on schedule every 5 day;
?????????????(drop event)
??????????????????:
????drop event [if exists] event_name
?????????????洴????e_test???
????drop event e_test
???????????????????????????????error 1513(HY000):unknown event???????ü???if exists
????drop event if exists e_test
??????????my.ini????my.cnf???????event_scheduler=1???????????mysql???????????event????????????.