CREATE TABLE test1(id int, col1 INT); CREATE TABLE test2(id int, col1 INT);CREATE TRIGGER testref AFTER INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 values (old.id,old.col1);CREATE TRIGGER testref AFTER UPDATE ON test1 FOR EACH ROW BEGIN INSERT INTO test2 values (old.id,old.col1);CREATE TRIGGER testref AFTER DELETE ON test1 FOR EACH ROW BEGIN INSERT INTO test2 values (old.id,old.col1);
old.id,old.col1,这些是字段名吗?还是什么
create trigger appInfo_trigger before update on appInfo for each row 少了一个before,我找了老半天,好像这跟mysql版本有关系
CREATE TABLE test2(id int, col1 INT);CREATE TRIGGER testref AFTER INSERT ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 values (old.id,old.col1);CREATE TRIGGER testref AFTER UPDATE ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 values (old.id,old.col1);CREATE TRIGGER testref AFTER DELETE ON test1
FOR EACH ROW BEGIN
INSERT INTO test2 values (old.id,old.col1);
before update on appInfo
for each row
少了一个before,我找了老半天,好像这跟mysql版本有关系