MySQL触发数据拷贝

Question

我有一个看起来像这样的触发器:

delimiter //
 create trigger tracker after insert on Items for each row
      begin

      end; //
delimiter ;

我需要将插入列的id、type和date_created插入到另一个表中作为

INSERT INTO Tracker (table_id, type, date) VALUES ( ??? );

我不确定如何在触发器中获取这些数据字段。有人可以给我提示吗

Answer 1

您可以使用 NEW.column_name 获取触发器中的插入值

INSERT INTO Tracker (table_id, type, date)
VALUES ( NEW.id_col_traker,NEW.col,NEW.col );

Within the trigger body, the OLD and NEW keywords enable you to access columns in the rows affected by a trigger. OLD and NEW are MySQL extensions to triggers; they are not case sensitive.

Trigger Syntax and Examples