//每一段代码运行一次,总共4段,一定要分开!

use d_taiwan;
select @@event_scheduler;
set global event_scheduler = on;
select @@event_scheduler;


CREATE PROCEDURE reset_create_role() 
update d_taiwan.limit_create_character set count=0;


CREATE EVENT  event_reset_create_role
ON SCHEDULE
EVERY '1' day STARTS '2021-09-12 00:00:00'
DO 
call reset_create_role();


alter event event_reset_create_role enable;
上一篇 下一篇