GetTheAnswer - Ask Questions, Get Answers about everything

this isn't working

DROP TRIGGER IF EXISTS `trigger_name`

DROP TRIGGER cannot be used together with the handy MYSQL extension "IF EXISTS". Other 5.0 features, like PROCEDUREs and FUNCTIONs however, do have this feature.

If you want to test for the existence of a trigger before removing it, you can do the following test before you delete it:

SELECT COUNT(*) FROM information_schema.TRIGGERS where TRIGGER_NAME = {yourtriggerhere};