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

18 votes150 views6 answers
Creating table in MySQL
SQL
-2 votes149 views1 answer
Group functions in sql
SQL
2 votes153 views2 answers
Sql percentage
SQL
1 vote156 views2 answers
How to search date in sql query
SQL
0 vote148 views1 answer
Double in sql server example
SQL
0 vote179 views1 answer
Insert output identity
SQL
0 vote153 views1 answer
Sql datediff month
SQL
11 votes163 views5 answers
Sql server reset identity
SQL
12 votes168 views4 answers
Psql command not found
SQL
1 vote144 views1 answer
Create sample data postgresql
SQL