Summary - Trigger

Update stock with an AFTER INSERT trigger.

A trigger runs automatically on an event. BEFORE for validation, AFTER for logging.

CREATE TRIGGER log_insert
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
  INSERT INTO log VALUES (NEW.id);
END;

Summary trigger.

The trigger log_insert is created.

Exercise Summary - Trigger

Summary: create the log_insert trigger with AFTER INSERT.

Show example solution

CREATE TRIGGER log_insert
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
  INSERT INTO log VALUES (NEW.id);
END