mysql trigger example
-- The following statement creates an AFTER UPDATE trigger on the sales table: DELIMITER $$ CREATE TRIGGER after_sales_update AFTER UPDATE ON sales FOR EACH ROW BEGIN IF OLD.quantity <> new.quantity THEN INSERT INTO SalesChanges(salesId,beforeQuantity, afterQuantity) VALUES(old.id, old.quantity, new.quantity); END IF; END$$ DELIMITER ;