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

5 votes341 views2 answers
Oracle list columns schema
SQL
0 vote372 views1 answer
Bitmap join index
SQL
11 votes330 views2 answers
Oracle all source
SQL
0 vote336 views1 answer
Sql bild in function
SQL
0 vote341 views1 answer
Firebird where
SQL
0 vote359 views1 answer
Change role postgres
SQL
0 vote325 views2 answers
Get all index postgres
SQL
10 votes350 views1 answer
Oracle dba_dependencies
SQL
0 vote357 views1 answer
How to make case insensitive in sql
SQL
3 votes316 views1 answer
Difference sql vs mysql
SQL