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

5 votes342 views4 answers
Describe table postgres
SQL
0 vote374 views1 answer
Hoq to import database source
SQL
0 vote352 views1 answer
How to create a table in sql stack overflow
SQL
0 vote347 views2 answers
Sql server select where date
SQL
1 vote330 views1 answer
Mysql select row with max value group by
SQL
2 votes389 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote388 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote341 views1 answer
Mysql xampp reset root password
SQL
0 vote367 views1 answer
Raiserror with nowait
SQL
0 vote373 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL