How do I create and manage MySQL 5 triggers?
Under the database node, there is a triggers node with all the triggers in the database (see picture). To create the new trigger, you need to right-click the triggers node and choose “New trigger” option. A new window appears with the empty space for typing in your trigger statement. You are typing something like this: CREATE TRIGGER testref BEFORE INSERT ON test1 FOR EACH ROW BEGIN INSERT INTO test2 SET a2 = NEW.a1; DELETE FROM test3 WHERE a3 = NEW.a1; UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1; END You don’t need to worry about setting and reseting the delimiters. Just type in the trigger and click the “Create trigger” button. To drop the trigger, right-click the trigger in the tree-view and choose “Drop trigger” option.
