trigger on insert and update code example

Example 1: trigger before insert

INSERT INTO WorkCenters(name, capacity)
VALUES('Mold Machine',100);

CREATE TRIGGER trigger_name
BEFORE INSERT
   ON table_name FOR EACH ROW

BEGIN

   -- variable declarations

   -- trigger code

END;