You are in the labyrinth/archive. Click here for the new exmosis.net.

Up

  • (none)

My Sql Triggers

created 2008-02-29 10:02:12

Notes to remember on MySQL triggers:

  • 2 identical triggers (same action on the same table) can't be created, even if they have different names. See http://bugs.mysql.com/bug.php?id=10946

  • Use "SHOW TRIGGERS" to get a list of triggers. This does something like: SELECT TRIGGERNAME, EVENTMANIPULATION, EVENTOBJECTTABLE, ACTIONSTATEMENT FROM INFORMATIONSCHEMA.TRIGGERS WHERE TRIGGERSCHEMA='dbname_';

  • MySQL 5.0 Triggers Docs

  • MySQL Triggers FAQ

Down

  • (none)
ckpoevtugba pxcbrighton