mysql event

最新推荐文章于 2023-02-02 22:26:53 发布

转载最新推荐文章于 2023-02-02 22:26:53 发布 · 691 阅读

JAVA 专栏收录该内容

34 篇文章

订阅专栏

本文详细介绍了如何在MySQL中管理Events，包括查看Events、检查Events状态、开启Events功能、创建Events以及修改Events的详细步骤。

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
#