List:General Discussion« Previous MessageNext Message »
From:Jesse Date:October 5 2007 11:34am
Subject:DROP TRIGGER IF EXISTS throws error??
View as plain text  
I'm attempting to restore a couple of backups, and part way through, I get 
the error:
You have an error in your SQL syntax; check the manual that corresponds to 
your MySQL server version for the right syntax to use near 'IF EXISTS 
alumni' at line 1

Query is: DROP TRIGGER IF EXISTS `alumni`;

Seems perfectly valid to me.  If I remove the "IF EXISTS" part, then I get 
the error, "trigger doesn't exist".  What's going on? This usually works 
fine.

I'm running version 5.0.45-community-nt

Thanks,
Jesse 

Thread
DROP TRIGGER IF EXISTS throws error??Jesse5 Oct
  • Re: DROP TRIGGER IF EXISTS throws error??Baron Schwartz5 Oct
  • Re: DROP TRIGGER IF EXISTS throws error??Jesse5 Oct