Mysql 触发器和自增重置

触发器
create trigger tg1 before insert on t1 for each row
begin
insert into t2(name) values(new.name)
end;
//创建一个tg1的触发器，在插入t1每行的时候，给t2插入新的名称，
如果插入的这个值有就是old.列表，如果这个列不存则new
create trigger tg2 before delete on t1 for each row
begin
delete from t2(name) where name =old.name
end;
 
select * from t1 union select * from t2;


//重排自增


alert table 表名 auto_increment=1;