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

2 votes352 views1 answer
SQL column name Postgre
SQL
1 vote353 views1 answer
Mysql event last execution
SQL
0 vote341 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
10 votes332 views4 answers
Primary key sql
SQL
2 votes339 views2 answers
Postgres select duplicate columns
SQL
9 votes382 views1 answer
Alter table column change data type to text mysql
SQL
3 votes380 views1 answer
Query less than datetime sql
SQL
0 vote311 views1 answer
Import sql mysql ubuntu
SQL
3 votes347 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote347 views1 answer
Horizontal join sqlite
SQL