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 vote198 views1 answer
Mysql to get column name in database
SQL
0 vote204 views1 answer
How to find total working hour in sql
SQL
0 vote189 views1 answer
Concatenate columns in table
SQL
1 vote186 views3 answers
Grant syntax in sql
SQL
0 vote176 views1 answer
How to find unique key in sql
SQL
1 vote204 views1 answer
Sql select where id not exists in another table
SQL
19 votes192 views2 answers
Mysql add column after another
SQL
0 vote241 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
4 votes192 views2 answers
Mysql select where starts with
SQL
0 vote184 views1 answer
Difference between cross apply and inner join
SQL