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 vote98 views1 answer
Hangfire clean script
SQL
17 votes158 views6 answers
Get last record in sql
SQL
2 votes143 views2 answers
Postgresql search all tables for column name
SQL
0 vote140 views1 answer
Value of sold product using having and group by in sql
SQL
5 votes126 views1 answer
Sqlite alter table add column
SQL
0 vote135 views1 answer
Logtash mysql cofiguration file
SQL
0 vote124 views1 answer
Close sql query vb.net
SQL
0 vote149 views1 answer
Truncate a table then insert data
SQL
0 vote138 views1 answer
Dump db only triggers mysql
SQL
0 vote135 views1 answer
Oracle synonym procedure
SQL