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 vote303 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote299 views2 answers
Postgres having
SQL
0 vote281 views1 answer
Sql string length postgresql
SQL
0 vote302 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote299 views1 answer
Postgresql interview questions
SQL
0 vote289 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote333 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote310 views1 answer
Login failed for user sql server
SQL
0 vote291 views1 answer
Insert array into mysql column
SQL
0 vote248 views1 answer
Java spring boot connect to sql server
SQL