mysql列数与行数不匹配_列计数与行%1处的值计数不匹配

匿名用户

您还应该研究新的触发器。

MySQL没有在错误中显示表名，因此您确实处于一个困难的境地。 下面是一个工作示例:use test;

create table blah (id int primary key AUTO_INCREMENT, data varchar(100));

create table audit_blah (audit_id int primary key AUTO_INCREMENT, action enum('INSERT','UPDATE','DELETE'), id int, data varchar(100) null);

insert into audit_blah(action, id, data) values ('INSERT', 1, 'a');

select * from blah;

select * from audit_blah;

truncate table audit_blah;

delimiter //

/* I've commented out "id" below, so the insert fails with an ambiguous error: */

create trigger ai_blah after insert on blah for each row

begin

insert into audit_blah (action, /*id,*/ data) values ('INSERT', /*NEW.id,*/ NEW.data);

end;//

/* This insert is valid, but you'll get an exception from the trigger: */

insert into blah (data) values ('data1');