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

3 votes211 views2 answers
Update Query in SQL Server
SQL
9 votes193 views2 answers
Get first 3 letters in sql
SQL
1 vote200 views2 answers
Drop table if exists test
SQL
1 vote193 views1 answer
Oracle check table space
SQL
1 vote190 views2 answers
Mysql select tables with name like
SQL
0 vote186 views1 answer
SQL get max per id
SQL
3 votes206 views1 answer
Postgres select max value
SQL
0 vote202 views1 answer
Sql commands in android
SQL
-1 vote207 views4 answers
Postgres between dates
SQL
18 votes179 views4 answers
Foreign key mySql
SQL