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

4 votes289 views2 answers
Mysql alter table set column unique
SQL
0 vote210 views1 answer
How to remove default in mysql
SQL
0 vote203 views4 answers
Mysql select bottom 10 rows
SQL
0 vote202 views1 answer
Mysql coonect sample code
SQL
0 vote268 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote216 views1 answer
Horizontal join sqlite
SQL
1 vote191 views1 answer
Oracle select first result
SQL
2 votes229 views1 answer
Sql OR
SQL
2 votes206 views1 answer
Wait delay in sql server
SQL
1 vote314 views1 answer
Python clean sql string
SQL