Question

mysql创建触发器时,如果触发的结果是insert语句,但是需要从两张表里分别选取数据,要怎么写

不能写成两条insert语句啊，比如
insert into t1 select id from t2;
insert into t1 select name from t3;
?
怎么写？

Answer 1

create trigger tr_xx_insert_after after insert on t2 for each row insert into t3(xx) values (xx);