create trigger X before insert on product for each row insert into operate values(null, 'insert product',now());改為試試 Create trigger X on product after insert as insert into operate select null,'insert product',getdate() from inserted
create table operate (op_id int auto_increment,op_name varchar(20),op_time varchar(20));
看提示 ERROR 1048:Column 'op_id' cannot be null.op_id設置了不為nullcreate table operate ( op_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, ,Col2..... ) AUTO_INCREMENT = 100;--自增初始值。gocreate trigger X before insert on product for each row insert into operate(Col2,Col3) --指定列 values( 'insert product',now());
on product for each row
insert into operate values(null, 'insert product',now());改為試試
Create trigger X on product
after insert
as
insert into operate select null,'insert product',getdate() from inserted
'截至2011-10-21 17:35:50 用户结帖率0.00%当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖
ERROR 1048:Column 'op_id' cannot be null.op_id設置了不為nullcreate table operate (
op_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
,Col2.....
)
AUTO_INCREMENT = 100;--自增初始值。gocreate trigger X before insert
on product for each row
insert into operate(Col2,Col3) --指定列
values( 'insert product',now());