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 vote211 views1 answer
Sql declare variable single line
SQL
-1 vote192 views3 answers
Mysql get age from date
SQL
11 votes197 views2 answers
Oracle all source
SQL
0 vote208 views1 answer
Sql get year from datetime field
SQL
1 vote217 views1 answer
Sql not equal multiple columns
SQL
0 vote200 views2 answers
Null value in column violates not-null constraint
SQL
0 vote206 views1 answer
Rename constraint postgresql
SQL
0 vote215 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote201 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote239 views1 answer
Traccar mysql
SQL