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 vote127 views1 answer
Mysql select all where count more than"
SQL
0 vote180 views1 answer
How to compile a function in oracle
SQL
0 vote141 views4 answers
Open mysql port bitnami tomact
SQL
1 vote151 views1 answer
Postgresql not in
SQL
0 vote131 views1 answer
R write csv without index
SQL
0 vote133 views1 answer
Narural join
SQL
0 vote137 views1 answer
Unique index in mysql
SQL
1 vote126 views3 answers
Get all tables postgres
SQL
1 vote131 views1 answer
Mariadb alter user host
SQL
1 vote123 views1 answer
Cross schema query oracle 2 users
SQL