-- 查看具体的事件执行情况
-- SELECT * FROM information_schema.events WHERE EVENT_SCHEMA='test' and EVENT_NAME='e_test';
-- test:是数据库名称
-- e_test: 具体的事件名称
-- insert into Courier_API_Item (qty, length, width, height, weight ) VALUES (1, 11,11,11,22)
CREATE DEFINER=`root`@`localhost` EVENT `SQL_Event` ON SCHEDULE EVERY 10 SECOND STARTS '2022-07-18 22:37:00' ON COMPLETION PRESERVE ENABLE DO insert into Courier_API_Item (qty, length, width, height, weight ) VALUES (1, 11,11,11,22)
show VARIABLES like 'event%'; -- 若为OFF,则执行下列指令
-- 开启
SET GLOBAL event_scheduler = 1;
SET GLOBAL event_scheduler = ON;
-- 关闭
SET GLOBAL event_scheduler = 0;
SET GLOBAL event_scheduler = OFF;
-- //禁用事件
ALTER EVENT SQL_Event DISABLE;
-- //启用事件
ALTER EVENT SQL_Event ENABLE;
-- 查看所有事件
SHOW EVENTS;
-- 查看具体的事件执行情况
SELECT * FROM information_schema.events WHERE EVENT_NAME = 'SQL_Event' ; -- 查询事件详情
SQL Event
于 2022-07-18 23:03:14 首次发布