Question

mysql，要在我建立的表中建立一个触发器，但是触发器建立后无法插入数据，一插入就是错误

代码如下
create table product (
id int(10) not null unique primary key,
name varchar(20) not null,
function varchar(50),
company varchar(20) not null,
address varchar(50)
);
create table operate(
op_id int(10) not null unique primary key auto_increment,
op_name varchar(20) not null,
op_time time not null
);
create trigger tproduct_bf_insert before insert on product for each row
insert into operate values('null','insert product','now()');

create trigger tproduct_af_update after update on product for each row
insert into operate values('null','update product','now()');

create trigger tproduct_af_del after delete on product for each row
insert into operate values('null','delete product','now()');

insert into product
values ('1','abc','专治感冒','上海abc制药','上海市分厂');
然后就错误，显示错误
incorrect integer value null for column op_id at row 1

Answer 1

单引号加多了，整型和函数都成了字符串，有意义的数还好，null就自动转型失败了。

追问

你好，能不能告诉一下该如何改动呢，举个代码实例

追答

values(null,'insert',now())

追问

好的谢谢

Answer 2

数据裤

追问

数据库已经建立了