delimiter $
create trigger trigger_vip – 触发器名 随便取
after DELETE on vip – 监听地点(vip表)监听事件 delete(之后)
for each row
begin – 触发事件 执行sql语句
insert into record(record) VALUES(old.vip);//删的哪个 就加哪个
flush privileges;
end$
drop trigger trigger_vip - - 删除触发器