法建器
Server： MYSQL
Server前端：HeidiSQL
器代：

SQL code

create trigger KEYIN_AUafter inserton keyin_infofor EACH ROWBEGINinsert into keyout_info(KEYINNO,Serial_NO)values( NEW.KEYINID,NEW.Serial_NO)END

提示：
SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 7

但是我比了上的一些代，感有啥啊。在insert句和END後面分加分（delimiter是分），也有效果。

[解决办法]
create trigger KEYIN_AU
after insert
on keyin_info
for EACH ROW
insert into keyout_info(KEYINNO,Serial_NO)values( NEW.KEYINID,NEW.Serial_NO) ;

[解决办法]
create trigger KEYIN_AU
after insert
on keyin_info
for EACH ROW
BEGIN
insert into keyout_info(KEYINNO,Serial_NO)values( NEW.KEYINID,NEW.Serial_NO);
END
少个;