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

15 votes227 views1 answer
Mysql int range
SQL
0 vote236 views4 answers
How to connect form to database
SQL
2 votes243 views1 answer
Sql OR
SQL
0 vote228 views1 answer
Sql query to select records entered in last 24 hours
SQL
24 votes197 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
2 votes244 views1 answer
How to delete columns in sql
SQL
0 vote222 views1 answer
SQL Server format datetime
SQL
-1 vote221 views3 answers
Check table exist postgresql
SQL
0 vote221 views1 answer
In mysql workbench contnent not feching
SQL
1 vote264 views1 answer
UseSqlServer no definition
SQL