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

123 votes1K views5 answers
Sql where contains
SQL
0 vote162 views1 answer
Automatically update database last seen datetime in sql
SQL
3 votes150 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
1 vote158 views1 answer
How to subtract from the value of a table in sql
SQL
1 vote207 views1 answer
Sql oracle update multiple rows
SQL
0 vote105 views1 answer
Update row in sqlite python
SQL
4 votes196 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote162 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
39 votes238 views4 answers
Select duplicates in sql
SQL
13 votes150 views5 answers
Alter table query sql server change column
SQL