触发器
课程:SQL · 编程练习
SQL编程练习 - 触发器
练习内容
-- 创建插入触发器(记录日志)\nDELIMITER //\nCREATE TRIGGER after_user_insert\nAFTER INSERT ON users\nFOR EACH ROW\nBEGIN\n INSERT INTO user_logs (user_id, action, created_at)\n VALUES (NEW.id, 'created', NO
课程:SQL · 编程练习
SQL编程练习 - 触发器
-- 创建插入触发器(记录日志)\nDELIMITER //\nCREATE TRIGGER after_user_insert\nAFTER INSERT ON users\nFOR EACH ROW\nBEGIN\n INSERT INTO user_logs (user_id, action, created_at)\n VALUES (NEW.id, 'created', NO