Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run ยป
HTML / CSS / JS
DELIMITER // CREATE TRIGGER before_user_update BEFORE UPDATE ON users FOR EACH ROW BEGIN SET NEW.updated_at = NOW(); IF OLD.email != NEW.email THEN SET NEW.email_verified = 0; END IF; END // CREATE TRIGGER after_user_update AFTER UPDATE ON users FOR EACH ROW BEGIN IF OLD.status != NEW.status THEN INSERT INTO user_status_log (user_id, old_status, new_status, changed_at) VALUES (NEW.id, OLD.status, NEW.status, NOW()); END IF; END // DELIMITER ;
Result
Open