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 vote290 views1 answer
Linebreak sql
SQL
1 vote298 views1 answer
Postgresql round double precision
SQL
20 votes275 views2 answers
Mysql bigint max value
SQL
2 votes268 views2 answers
Oracle multiple insert
SQL
1 vote278 views1 answer
Oracle stop job
SQL
0 vote307 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote293 views1 answer
Oracle query archivemode
SQL
0 vote284 views1 answer
How to find username and password in oracle 18c
SQL
0 vote291 views1 answer
Oracle temporary table
SQL
-2 votes273 views1 answer
How to open database
SQL