Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
DELIMITER // CREATE TRIGGER before_order_delete BEFORE DELETE ON orders FOR EACH ROW BEGIN -- Archive the order before deleting INSERT INTO orders_archive (order_id, customer_id, total, status, archived_at) VALUES (OLD.id, OLD.customer_id, OLD.total, OLD.status, NOW()); END // CREATE TRIGGER after_order_delete AFTER DELETE ON orders FOR EACH ROW BEGIN UPDATE customers SET total_orders = total_orders - 1 WHERE id = OLD.customer_id; END // DELIMITER ;
Result
Open