改成 create trigger audit_trigger before insert on test_table1 for each row begin insert into test_table2 values(:new.a,:new.b); end; 试试
好像不是主键的问题啊 改成如下: 还是有错误create table test_table1(a int ,b int); create table test_table2(c int ,d int); create trigger audit_trigger before insert on test_table1 for each row begin insert into test_table2 values(1, 0); end; 下面这样也是有错 create table test_table1(a int ,b int); create table test_table2(c int ,d int); create trigger audit_trigger before insert on test_table1 for each row begin insert into test_table2 values(:new.a, :new.b); end;
create trigger audit_trigger
before insert on test_table1
for each row
begin
insert into test_table2 values(:new.a,:new.b);
end;
试试
改成如下: 还是有错误create table test_table1(a int ,b int);
create table test_table2(c int ,d int);
create trigger audit_trigger
before insert on test_table1
for each row
begin
insert into test_table2 values(1, 0);
end;
下面这样也是有错
create table test_table1(a int ,b int);
create table test_table2(c int ,d int);
create trigger audit_trigger
before insert on test_table1
for each row
begin
insert into test_table2 values(:new.a, :new.b);
end;