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

11 votes177 views2 answers
How to import mysql database command line
SQL
16 votes181 views2 answers
Add column if not exists mysql
SQL
51 votes241 views6 answers
Change column name sql
SQL
4 votes176 views1 answer
Refresh postgres config
SQL
6 votes164 views1 answer
Postgresql add enum value
SQL
0 vote143 views2 answers
Influxdb delete measurement based on date
SQL
2 votes176 views1 answer
Sql server: select column values as comma separated string
SQL
1 vote169 views1 answer
Pv mysql import
SQL
2 votes175 views2 answers
Created at and updated at in mysql
SQL
1 vote165 views1 answer
Delete mysql from mac
SQL