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;
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;