mysql关于一些触发器的一些操作

当t_user表添加一条记录时同时也添加_id_generator表对应ID数据：
CREATE TRIGGER `gid` AFTER INSERT ON `t_user` FOR EACH ROW insert into t_id_generator values(new.id);

当t_user表删除一条记录时同时也删除t_id_generator表对应ID的数据：

TRIGGER `dgid` BEFORE delete ON `t_user` FOR EACH ROW delete from `t_id_generator` where t_id_generator.id=old.id ;

删除触发器：drop trigger dgid;