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 vote229 views1 answer
Get who is hired in specific month in sql
SQL
2 votes232 views1 answer
Mysql sysdate - 1 day
SQL
0 vote227 views1 answer
Print orcale
SQL
2 votes249 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote266 views1 answer
Postgre query date
SQL
2 votes258 views1 answer
Sql find not in list
SQL
5 votes238 views1 answer
Sysdate in oracle sql
SQL
0 vote232 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
1 vote244 views3 answers
Update from select sqlite
SQL
0 vote194 views1 answer
Online sql compiler
SQL