Procedure and trigger

Write a balance procedure and an audit trigger.

In this challenge you will write a procedure and an audit trigger.

CREATE TRIGGER audit_product
AFTER UPDATE ON products
FOR EACH ROW
BEGIN
  INSERT INTO audit_log VALUES (OLD.name, NEW.name, NOW());
END;

This query audits changes.

The trigger audit_product is created.

Exercise Procedure and trigger

Create the audit_product trigger with AFTER UPDATE ON products.

Show example solution

CREATE TRIGGER audit_product
AFTER UPDATE ON products
FOR EACH ROW
BEGIN
  INSERT INTO audit_log VALUES (OLD.name, NEW.name, NOW());
END

Add AFTER UPDATE

CREATE TRIGGER audit_product
____ ON products

Show answer

CREATE TRIGGER audit_product
AFTER UPDATE ON products

Next lesson: Optimization