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 votes338 views6 answers
In in sql
SQL
0 vote380 views1 answer
Mysql command line top 10
SQL
0 vote347 views1 answer
Sql anywhere create procedure
SQL
2 votes354 views1 answer
Sql column values comma separated
SQL
0 vote400 views1 answer
Stratified sampling sql
SQL
1 vote379 views1 answer
Connect to mysql database ubuntu
SQL
0 vote353 views1 answer
How convert into in in sql query
SQL
0 vote345 views1 answer
Postgres copy command
SQL
-1 vote367 views2 answers
Postgresql user permissions to database
SQL
0 vote349 views1 answer
Get number of rows in every table mysql
SQL