mysql - 触发器的语法错误，无法修复，具有pra1表和pra1_audit触发器表

Question

触发器的语法错误，无法修复。我有pra1表和pra1_audit触发器表，用于pra1。

select * from pra1; 

CREATE TABLE pra1_audit  (     id INT AUTO_INCREMENT PRIMARY KEY, 
    id_menu INT NOT NULL,      id_productline INT NOT NULL, 
    Order_ID INT NOT NULL  );   


  DELIMITER $$  CREATE TRIGGER before_pra1_update   BEFORE UPDATE ON pra1  FOR EACH ROW   BEGIN  INSERT INTO pra1_audit  SET action = 'update',  id_menu= OLD.id_menu,  Order_ID = OLD.Order_ID; 
       END$$  DELIMITER ;

Answer 1

执行插入时，您需要使用

INSERT INTO pra1_audit (action, id_menu, Order_id) 
    values( 'update', OLD.id_menu, OLD.Order_ID);