更新时间: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());