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

7 votes138 views1 answer
Oracle set sequence value to max(id)
SQL
3 votes146 views1 answer
Sql is not like
SQL
0 vote142 views1 answer
Sql select with apostrohpe
SQL
17 votes168 views6 answers
MySQL ORDER BY
SQL
0 vote143 views1 answer
Xampp increame mysql speed
SQL
7 votes150 views5 answers
Sql remove spaces
SQL
5 votes148 views2 answers
Mysql import gzip db
SQL
0 vote133 views1 answer
Postgresql get current user name
SQL
4 votes131 views3 answers
Copy table postgres
SQL
0 vote141 views1 answer
Search column name sql
SQL