不需要用TRIGGER insert into c select a.*,b.ADDRESS,b.TEL from a inenr join b on a.id=b.id
delimiter |CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END; |delimiter ; ================= 这段给力
insert into c
select a.*,b.ADDRESS,b.TEL from a inenr join b on a.id=b.id
FOR EACH ROW BEGIN
INSERT INTO test2 SET a2 = NEW.a1;
DELETE FROM test3 WHERE a3 = NEW.a1;
UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
END;
|delimiter ;
=================
这段给力