Mysql trigger after update

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$$

Similar codes

0 vote342 views1 answer
Into operator in sql
SQL
0 vote326 views1 answer
Get last date join sql
SQL
0 vote321 views1 answer
Laravel eloquent get generated sql
SQL
1 vote327 views1 answer
Update and replace mysql
SQL
0 vote350 views1 answer
What is top n result in sql
SQL
0 vote327 views1 answer
MySQL get all previous date record
SQL
0 vote337 views2 answers
Timing sql queries
SQL
1 vote336 views1 answer
Sql server datetime vs datetime2
SQL
0 vote302 views1 answer
Store query result in variable sql
SQL
4 votes318 views3 answers
Count with where
SQL