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

1 vote107 views1 answer
Postgresql can you have null foreign key
SQL
0 vote108 views1 answer
Rails sql query converstion
SQL
0 vote103 views1 answer
Sql get user account
SQL
11 votes102 views1 answer
Mysql order by two columns priority
SQL
0 vote119 views1 answer
Postgres foreign key multiple columns
SQL
-1 vote97 views1 answer
Extract Data from SQL Server into XML Format
SQL
3 votes61 views1 answer
System.debug apex
SQL
0 vote100 views1 answer
Order by ip address sql
SQL
2 votes100 views1 answer
Get first 3 letters name in sql
SQL
0 vote93 views1 answer
Change default schema sql server
SQL