且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

错误"1064";在mysql中创建触发器?

更新时间:2022-12-01 10:26:01

触发器既不是例程也不是存储过程,
因此不需要BEGIN...END,而且表名区分大小写

trigger are not routine nor stored procedure,
so there is not need for BEGIN...END, plus the table name is case sensitive

CREATE TRIGGER Employee_Trigger
AFTER insert ON Employee
FOR EACH ROW
INSERT INTO test.Employee_log values(new.id,new.first_name,
  new.last_name,new.start_date,new.end_date,
  new.city,new.description,curtime());