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

2 votes200 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
3 votes187 views2 answers
Install mysql powershell
SQL
5 votes218 views1 answer
How to use rank function in sql
SQL
0 vote184 views1 answer
Sql quary intervewi question
SQL
0 vote213 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote194 views1 answer
Sql server union if table exist
SQL
0 vote198 views1 answer
Create domain sql
SQL
0 vote199 views1 answer
Foreign key multiple columns
SQL
0 vote181 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote208 views1 answer
Oracle insert single quote in string
SQL