您的位置:首页 > 博客中心 > 数据库 >

mysql 创建事件、存储过程

时间:2022-03-14 02:22

CREATE PROCEDURE test1 ()
BEGIN
INSERT INTO `user`(bookname) VALUES(‘asdf‘);
END;

CREATE EVENT if not exists e_test
on schedule every 30 second
on completion preserve
do call test1();

set global event_scheduler=1;
alter event e_test ON COMPLETION preSERVE DISABLE;
alter event e_test ON COMPLETION preSERVE ENABLE;

热门排行

今日推荐

热门手游