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 vote132 views1 answer
How to select an index in oracle sql
SQL
1 vote129 views1 answer
Input in mysql
SQL
0 vote125 views1 answer
Oracle current session details
SQL
5 votes124 views1 answer
How to get all dates in a month in oracle
SQL
5 votes138 views1 answer
Oracle create table comment
SQL
8 votes119 views1 answer
Today minus 15 days postgresql
SQL
11 votes78 views1 answer
Reset identity sql server
SQL
0 vote127 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote131 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote130 views1 answer
Oracle NLS_CHARACTERSET
SQL