我正在尝试一个非常简单的触发器
CREATE TRIGGER trg_product_size AFTER UPDATE ON tb_product
FOR EACH ROW
BEGIN
insert into test_trigger
(product_id,product_size_values)
select product_id,product_size_values
from tb_product
where product_id = NEW.product_id;
END
但我得到了 2000 行,不仅更新了一行,所有内容都tb_product
感谢您的帮助
如果只想捕获product_size_values更改;可以执行以下操作:
CREATE TRIGGER trg_product_size AFTER UPDATE ON tb_product
FOR EACH ROW
BEGIN
IF (NEW.product_size_values != OLD.product_size_values) THEN
INSERT INTO test_trigger (product_id, product_size_values)
VALUES (NEW.product_id, NEW.product_size_values)
;
END IF;
END