Use eg3_db;
Show tables;
Show variables like '% % scheduler;
The set global event_scheduler=1;
The drop event if the exists e1;
Delimiter $$
The create event e1
On the schedule every 10 second/* strats' 2020-2-13 22:25:00 'ends' 2020-2-13 22:30:00 */
On completion the not preserve the enable
Do
The begin
Insert into student1 values (0, 'now (), 80);
End $$
Delimiter.
Select * from student1;
Show the events;
/* the alter event e1 disable/enable; */
/*, join the strats... Ends complains, cannot insert date */