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 vote334 views1 answer
Mysql last 6 months
SQL
3 votes305 views5 answers
Mysql get last inserted id
SQL
0 vote303 views1 answer
Sql get table last modified time
SQL
1 vote329 views3 answers
Divide by zero error in sql
SQL
0 vote327 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
2 votes291 views3 answers
Mysql cheat sheet
SQL
1 vote320 views1 answer
Psql lst trigger
SQL
0 vote325 views1 answer
Mysql url data type
SQL
1 vote342 views1 answer
Mamp mysql path mac
SQL
0 vote298 views1 answer
How to count with except in psql
SQL