1
set global event_scheduler=off;
2
drop database if exists events_test;
3
create database events_test;
5
create table execution_log(name char(10));
6
create event abc1 on schedule every 1 second do
7
insert into execution_log value('abc1');
8
create event abc2 on schedule every 1 second do
9
insert into execution_log value('abc2');
10
create event abc3 on schedule every 1 second do
11
insert into execution_log value('abc3');
12
create table event_like like mysql.event;
13
insert into event_like select * from mysql.event;
14
alter table mysql.event
15
change column body body longtext character set utf8 collate utf8_bin;
16
"Now we restart the server"