要求在T1增加一行记录时，T2表也相应增加一行 当然 要求T2增加的记录必须满足：T2.tid=T1.id T2.title=T1.title SQL code: create trigger tr_t1_ai after insert on t1 for each row insert into t2(tid,title) values (new.id,new.title);
我就这样写的 但是不行 编译触发器不报错 但是T1插入记录时 报错
Can't update table 'T1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. 啊，对 应该是这个原因了，那怎么解决呢
请高手指点,我对一张表查询后再更新,查询是子查询,报错: You can't specify target table 'a_table' for update in from clause 完整SQL语句是 UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
