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 vote248 views1 answer
Sql database size
SQL
0 vote184 views1 answer
Implicit inner join table alias with id values
SQL
1 vote245 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
3 votes189 views1 answer
Select sequence oracle
SQL
0 vote236 views1 answer
Sql count matching group by
SQL
0 vote180 views1 answer
Oracle SQL join three tables and group by column
SQL
1 vote232 views1 answer
Oracle check table lock
SQL
0 vote143 views1 answer
Count char in java
SQL
0 vote170 views1 answer
Uuid sqlalcomany
SQL
0 vote230 views1 answer
Sql get table last modified time
SQL