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 vote278 views1 answer
Character count sql
SQL
2 votes267 views1 answer
Sql ignore accents
SQL
0 vote269 views2 answers
Azure sql-datenbank
SQL
17 votes276 views6 answers
Get last record in sql
SQL
2 votes310 views2 answers
Oracle create table if not exists
SQL
1 vote290 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote285 views1 answer
Select row with latest date mysql
SQL
15 votes295 views3 answers
Postgresql change column type
SQL
16 votes329 views3 answers
Get count of duplicate records
SQL
0 vote265 views1 answer
How to change the field size of an existing column
SQL