mysql event

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
#