use eg3_db;
show tables;
show variables like '%scheduler%';
set global event_scheduler = 1;
drop event if exists e1;
delimiter $$
create event e1
on schedule every 10 second /*strats '2020-2-13 22:25:00' ends '2020-2-13 22:30:00'*/
on completion not preserve enable
do
begin
insert into student1 values(0,'now()',80);
end$$
delimiter ;
select * from student1;
show events;
/*alter event e1 disable/enable;*/
/*問題，加入strats...ends會報錯，不能插入日期*/
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/69481.html
標籤：疑難問題
上一篇：sqlserver 問題
下一篇：mysql問題