记录触发器的写法。begin和end之间写触发的动作,要写分号。
CREATE TRIGGER audit_log AFTER INSERT ON employees_test FOR EACH ROW BEGIN INSERT INTO audit VALUES(NEW.ID,NEW.NAME); END
记录触发器的写法。begin和end之间写触发的动作,要写分号。
CREATE TRIGGER audit_log AFTER INSERT ON employees_test FOR EACH ROW BEGIN INSERT INTO audit VALUES(NEW.ID,NEW.NAME); END