-- 创建插入触发器(记录日志) DELIMITER // CREATE TRIGGER after_user_insert AFTER INSERT ON users FOR EACH ROW BEGIN INSERT INTO user_logs (user_id, action, created_at) VALUES (NEW.id, 'created', NOW()); E
-- 创建插入触发器(记录日志) DELIMITER // CREATE TRIGGER after_user_insert AFTER INSERT ON users FOR EACH ROW BEGIN INSERT INTO user_logs (user_id, action, created_at) VALUES (NEW.id, 'created', NOW()); E