1. 查看Events:
mysql> show events\G
mysql> show full events\G
mysql> SELECT * FROM mysql.event;
mysql> SELECT * FROM information_schema.events;
2. 查看Events是否开启
mysql> select @@event_scheduler;
mysql> show variables like 'event_scheduler';
3. 开启Events方法:
mysql> set GLOBAL event_scheduler=ON;
或
mysql> set GLOBAL event_scheduler=1;
4. create event
delimiter #
create event getEmpDpmtEvent
on schedule every 1 day starts date_add(date(curdate()+1),interval 3 hour)
on completion preserve enable
do
begin
call getEmpDpmt();
end
#
5. alter event
delimiter #
alter event getEmpDpmtEvent
on schedule every 1 day starts date_add(date(curdate()+1),interval 3 hour)
on completion preserve enable
do
begin
call getEmpDpmt();
end
#