mysql触发器

1、MySQL触发器：DROP trigger IF EXISTS hmy;//分号必须要写
create trigger hmy
after insert on user
for each row
begin
delete from cat where id = 1;//分号不可以省略
end;
2、蠕虫复制：
　　insert into user (id,name) select id,name from user;