MySQL触发器将所有字段值复制到另一个表中，怎么办？ [英] MySQL trigger to copy all field values to another table, how?

问题描述

我有2个相同的表（100％相同），

I have 2 identical table (100% identical),

DELIMITER $$

CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `db`.`new_user` AFTER INSERT
ON `db`.`user`
FOR EACH ROW BEGIN
INSERT INTO db2.`users` COPY ALL INSERTED DATA
END$$

DELIMITER ;

INSER查询的外观如何？我必须一一指定所有字段名称吗？

How should the INSER query look like? Do I have to specifiy all field names one by one?

推荐答案

自 NEW 不是行标识符，而是引用由触发器操作的行中特定列的语法方式，您需要指定列名

Since NEW is not a row identifier but rather a syntactic way for referring to particular columns in a row being manipulated by a trigger, you need to specify column names

INSERT INTO db2.`users` VALUES(NEW.id, NEW.username, ...);

这篇关于MySQL触发器将所有字段值复制到另一个表中，怎么办？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！