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 vote142 views1 answer
Oracle create table auto generated primary key
SQL
0 vote141 views1 answer
Postgres where
SQL
12 votes159 views6 answers
Change mysql root password
SQL
0 vote138 views1 answer
Sqlite select split string
SQL
-1 vote89 views3 answers
Ubuntu install mssql
SQL
5 votes227 views2 answers
Mysql date greater than 30 days
SQL
0 vote154 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
10 votes105 views2 answers
Mysql select timestamp group by day
SQL
0 vote138 views1 answer
Postgres drop type
SQL
0 vote140 views1 answer
Désinstaller postgresql linux
SQL