stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
set global event_scheduler=1;
drop event if exists justonce;
drop table if exists t1,t2;
CREATE TABLE `t1` (
`id` int(10) unsigned NOT NULL auto_increment,
`c` varchar(50) NOT NULL,
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into t1 (c) values ('manually');
create event justonce on schedule at now() + interval 2 second do insert into t1
(c) values ('from justonce');
select sleep(3);
sleep(3)
0
select * from t1;
id	c	ts
1	manually	2006-12-17 11:39:11
2	from justonce	2006-12-17 11:39:13
affected rows: 2
select * from t1;
id	c	ts
1	manually	2006-12-17 11:39:11
2	from justonce	2006-12-17 11:39:13
affected rows: 2