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 vote245 views1 answer
Mysql config address
SQL
-1 vote255 views1 answer
Mysql coalesce
SQL
1 vote194 views1 answer
Sql update table remove spaces
SQL
0 vote257 views1 answer
Mysql installer no packages found
SQL
1 vote211 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote168 views1 answer
Import csv to mysql
SQL
51 votes310 views6 answers
Opera gx
SQL
1 vote183 views4 answers
Between vs in sql
SQL
0 vote199 views1 answer
Java sql connection
SQL
0 vote192 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL