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 vote219 views1 answer
Unique element in sql
SQL
3 votes209 views3 answers
How to set up an auto incrementing id db browser
SQL
54 votes342 views6 answers
Sql rename column
SQL
1 vote246 views1 answer
Primary key with prefix sql
SQL
0 vote280 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote220 views1 answer
Tsql pad left
SQL
0 vote216 views1 answer
Install sql server windows 10
SQL
0 vote212 views1 answer
Remove binlog mysql
SQL
2 votes214 views2 answers
Checking data type in sql server
SQL
2 votes228 views1 answer
Rails execute sql
SQL