mysql 定时器使用

[wangming1993]

delimiter //
drop procedure if exists test_proce//
create procedure test_proce()
begin
update `activity_groups` set createdAt = now() where id = 1;
end//
delimiter ;

drop event if exists test_event;
create event test_event
on schedule every 3 second
on completion preserve disable
do call test_proce();

alter event test_event on completion preserve enable;

select * from mysql.event;

delete from `mysql`.`event` where `db`='db' and `name`='test_event';

[wangming1993]

SELECT  *  FROM  information_schema.Routines WHERE ROUTINE_SCHEMA = 'admin-server';