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

1 vote201 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote198 views1 answer
Epoch time converter in snowflake
SQL
0 vote173 views1 answer
Apex for oracle 11g
SQL
2 votes181 views1 answer
Drop all foreign key constraints mysql
SQL
10 votes192 views6 answers
Sql between
SQL
3 votes213 views2 answers
How to View column names of a table in SQL
SQL
0 vote192 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote246 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote168 views1 answer
Pl sql join 3 tables
SQL
4 votes157 views1 answer
Add constraint fk
SQL