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

26 votes123 views2 answers
Mysql workbench download
SQL
5 votes124 views2 answers
To date oracle
SQL
14 votes136 views2 answers
Oracle limit rows
SQL
5 votes111 views1 answer
How to check nls format in oracle
SQL
-1 vote107 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote108 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote116 views1 answer
Search In the Data using ObjectName
SQL
6 votes135 views4 answers
Mysql get random row
SQL
0 vote114 views1 answer
Mysql grouping functions
SQL
8 votes118 views3 answers
Postgres database sizes
SQL