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 vote309 views1 answer
First mysql
SQL
0 vote325 views2 answers
How to find sql server agent jobs related to a database
SQL
5 votes338 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote343 views2 answers
Postgres select from last 3 months
SQL
3 votes331 views2 answers
Mysql import gz
SQL
1 vote312 views1 answer
Create temporal table in sql
SQL
-1 vote316 views2 answers
On update cascade
SQL
4 votes274 views1 answer
And or sql order of operations
SQL
0 vote366 views1 answer
Apt install sql server
SQL
6 votes313 views1 answer
Update left join mysql
SQL