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 vote159 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote181 views1 answer
Mysql where sum > 0
SQL
0 vote152 views1 answer
Less than and between in sql query
SQL
0 vote510 views1 answer
How to connect .sql data set to powerbi
SQL
2 votes151 views1 answer
Metasploit start postgresql
SQL
0 vote144 views1 answer
Exec procedure oracle
SQL
0 vote104 views1 answer
Delete all rows from table sqlite
SQL
3 votes152 views1 answer
Locate sql server
SQL
10 votes142 views6 answers
Mysql delete duplicates
SQL
2 votes136 views2 answers
Oracle create table if not exists
SQL