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

1 vote176 views2 answers
Mysql remove first and last character from string
SQL
6 votes192 views2 answers
Difference between join vs union
SQL
0 vote184 views1 answer
Mssql dockere
SQL
-3 votes165 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
4 votes163 views3 answers
Mysql update with join
SQL
1 vote178 views1 answer
Sql drop schema
SQL
0 vote172 views1 answer
Mysql query to add hours to column in table
SQL
2 votes176 views1 answer
Sqlite indexes
SQL
0 vote193 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
5 votes177 views1 answer
Mysql count lines
SQL