MySQL 某表新增数据后，向另一张表添加新数据

靖西网牛牛动态域名

2024-04-21

DELIMITER $$
CREATE TRIGGER `触发器名称` AFTER INSERT ON `原表名`
FOR EACH ROW
BEGIN
INSERT INTO `audit_log` (
`table_name`, `record_id`, `action_type`, `timestamp`
) VALUES (
'orders', NEW.id, 'INSERT', NOW()
);
END$$
DELIMITER ;

https://blog.51cto.com/u_16213343/8713389

浏览18069 / 回复0

返回发回复：评论……