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 vote295 views1 answer
Low level operator in dbms
SQL
0 vote303 views1 answer
Alasql delete column
SQL
0 vote303 views1 answer
Get only structure database mysql
SQL
8 votes293 views1 answer
Insert a select statement into a table
SQL
20 votes353 views4 answers
How to find average in sql
SQL
0 vote294 views1 answer
Sql find table by name
SQL
-1 vote331 views1 answer
Minus vs except in sql
SQL
1 vote299 views1 answer
Last 6 months postgresql
SQL
1 vote291 views1 answer
Mysql date diff in seconds
SQL
0 vote302 views2 answers
Sql 2 way of select unique
SQL