要求在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. 啊，对 应该是这个原因了，那怎么解决呢
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
