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 vote141 views1 answer
Mysql relationships between tables
SQL
2 votes101 views2 answers
Mysql limit
SQL
4 votes103 views1 answer
Sql any
SQL
6 votes117 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote113 views1 answer
How to save data in database in mysql node
SQL
0 vote110 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
6 votes112 views1 answer
Update left join mysql
SQL
0 vote93 views1 answer
Count the table indatabase
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
0 vote109 views1 answer
Exec procedure oracle
SQL