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 vote262 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote282 views3 answers
Sql procedure
SQL
0 vote268 views1 answer
Mysql filter based on datediff
SQL
-1 vote245 views2 answers
On delete set default sql server
SQL
0 vote254 views1 answer
Get employees if not contains in sql
SQL
16 votes338 views2 answers
Sql vs nosql
SQL
12 votes282 views2 answers
Select into insert sql server
SQL
1 vote263 views1 answer
Sql into vs insert into
SQL
1 vote250 views1 answer
Show indices in mysql table
SQL
0 vote270 views2 answers
PostgreSQL having
SQL