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 vote244 views1 answer
Postgres 11 add primary key
SQL
3 votes253 views1 answer
How to check schema privileges in oracle
SQL
1 vote257 views1 answer
Oracle finding duplicate records
SQL
2 votes248 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote267 views1 answer
Tsql update datetime
SQL
0 vote318 views2 answers
Insert data into multiple tables mysql
SQL
0 vote338 views1 answer
How to show current database in mysql
SQL
0 vote253 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote259 views1 answer
Postgres statistics
SQL
0 vote290 views10 answers
Sql statement checker corrector
SQL