1
create database if not exists mysqltest_events_test;
2
use mysqltest_events_test;
3
1
set global event_scheduler=off;
2
drop database if exists events_test;
3
create database events_test;
4
5
create table execution_log(name char(10));
5
create event abc1 on schedule every 1 second do insert into execution_log value('abc1');
6
create event abc2 on schedule every 1 second do insert into execution_log value('abc2');
7
create event abc3 on schedule every 1 second do insert into execution_log value('abc3');
8
select name from execution_log;
10
insert into mysql.event values ('db1','bad','select 42','root@localhost',NULL,1000,'MICROSECOND','2006-05-05 17:39:11','2006-05-05 17:39:20','2016-05-05 15:39:24','2016-05-05 15:39:11',NULL,'ENABLED','DROP','','comment1');
11
insert into mysql.event values ('db1','bad2','sect','root@localhost',NULL,1000,'SECOND','2006-05-05 17:39:11','2006-05-05 17:39:20','2016-05-05 15:39:24','2016-05-05 15:39:11',NULL,'ENABLED','DROP','','comment2');
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;
12
16
"Now we restart the server"