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

6 votes161 views2 answers
WHERE value IS sql
SQL
0 vote143 views1 answer
Delete duplicate rows
SQL
1 vote145 views1 answer
Decalre temp table sql
SQL
2 votes140 views1 answer
How to make insert script from table in SQL server
SQL
0 vote135 views1 answer
Sql server order by nulls last
SQL
0 vote156 views1 answer
How to change mysql port in xampp
SQL
5 votes156 views1 answer
Oracle nls parameters
SQL
0 vote146 views1 answer
Install squirrel sql ubuntu
SQL
0 vote141 views4 answers
Best data type to represent money in mysql
SQL
0 vote133 views1 answer
Mysql connection with sqlalchecmy
SQL