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 vote120 views1 answer
PSQL qith variables
SQL
6 votes121 views2 answers
Postgresql restore from dump
SQL
0 vote118 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote125 views1 answer
Default
SQL
0 vote130 views1 answer
What is mysql_pconnect
SQL
7 votes116 views2 answers
Phpmyadmin change password
SQL
0 vote114 views1 answer
Sql convert datetime to year
SQL
1 vote111 views1 answer
Postgres first_value in gropby
SQL
3 votes119 views2 answers
Mysql HAVING
SQL
1 vote111 views1 answer
Sql delete row with auto increment
SQL