触发器

课程: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