-
create database xiyundb;
drop table xiyundb.xiyun12;
create table xiyundb.xiyun12(
id int not null primary key auto_increment,
name varchar(60),
age int
);
use xiyundb;
drop PROCEDURE sp_xiyun12_10;
delimiter //
create procedure sp_xiyun12_10()
begin
declare n int;
set n=0;
repeat
insert into xiyundb.xiyun12(name,age) values(CONCAT('xiyun1',n),22);
commit;
set n=n+1;
until n>=10 end repeat;
end
//
delimiter ;
-- call sp_xiyun12_10();
select * from xiyundb.xiyun12;
create event if not exists e_xiyun12_5_10
on schedule every 5 second
on completion preserve
do
call sp_xiyun12_10();
create event if not exists e_xiyun12_5_truncate
on schedule every 5 hour
on completion preserve
do
truncate table xiyundb.xiyun12;
alter event e_xiyun12_5_10 ON COMPLETION PRESERVE ENABLE;
alter event e_xiyun12_5_truncate ON COMPLETION PRESERVE ENABLE;
set global event_scheduler =1;
select count(*) from xiyundb.xiyun12;