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 vote280 views2 answers
Sql for date greater than
SQL
2 votes275 views1 answer
Mariadb JSON_EXTRACT
SQL
19 votes258 views6 answers
Laravel sql query
SQL
0 vote272 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote272 views1 answer
SQL loop with cursor
SQL
1 vote281 views1 answer
Snowflake rename column name
SQL
0 vote255 views1 answer
Myswql show full processlist
SQL
0 vote316 views1 answer
Sql datum formatieren
SQL
0 vote266 views2 answers
T SQl Checking Your Username
SQL
0 vote280 views1 answer
Convert excel into sqllite db using python
SQL