mysql 触发器和事件

触发器例子

drop trigger if exists ttest;
delimiter ||
create trigger ttest
after insert on testa for each row
begin
   INSERT INTO testb(testbid) VALUES(new.testaid);
end;||

 

事务例子

eg1

drop event if exists etest;
delimiter ||
create event etest on schedule every 1 minute
on completion preserve
do delete from test where(testtime<'00:00:10');||

eg2

drop event if exists etest;
delimiter ||
create event etest on schedule every 1 day
on completion preserve
do delete from test where(datediff(now(),testtime)>14);||

windows event服务开启需要在my.ini文件的

[mysqld] 下加上如下语句
event_scheduler=ON