Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
CREATE TABLE IF NOT EXISTS audit_log ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, tbl VARCHAR(64), action ENUM('INSERT','UPDATE','DELETE'), record_id BIGINT, old_data JSON, new_data JSON, changed_at DATETIME DEFAULT NOW() ); DELIMITER // CREATE TRIGGER after_products_update AFTER UPDATE ON products FOR EACH ROW BEGIN INSERT INTO audit_log (tbl, action, record_id, old_data, new_data) VALUES ( 'products', 'UPDATE', NEW.id, JSON_OBJECT('price', OLD.price, 'stock', OLD.stock), JSON_OBJECT('price', NEW.price, 'stock', NEW.stock) ); END // DELIMITER ;
Result
Open