Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // -- BEFORE INSERT: auto-set slug from title CREATE TRIGGER before_article_insert BEFORE INSERT ON articles FOR EACH ROW BEGIN SET NEW.slug = LOWER(REPLACE(NEW.title, ' ', '-')); SET NEW.created_at = NOW(); END // -- AFTER INSERT: log to audit table CREATE TRIGGER after_article_insert AFTER INSERT ON articles FOR EACH ROW BEGIN INSERT INTO audit_log (table_name, action, record_id, changed_at) VALUES ('articles', 'INSERT', NEW.id, NOW()); END // DELIMITER ;
Result
Open