Is there white space at the end of the trigger name? A On Feb 20, 2012 10:04 PM, "Brent Clark" <brentgclarkl...@gmail.com> wrote:
> Hi Guys > > I wonder if someone could urgently help me > > Im trying to drop some triggers. But mysql says the trigger does not exist. > > I ran > > SELECT TRIGGER_SCHEMA, EVENT_OBJECT_TABLE, TRIGGER_NAME FROM > INFORMATION_SCHEMA.TRIGGERS > > > +----------------+--------------------+------------------------------------------+ > | TRIGGER_SCHEMA | EVENT_OBJECT_TABLE | TRIGGER_NAME > | > > +----------------+--------------------+------------------------------------------+ > | abc_db1 | foods | Foods Insert to Contributions,Search > | > > But if I run > > DROP TRIGGER `abc_db1`.`Foods Insert to Contributions\,Search`; > ERROR 1360 (HY000): Trigger does not exist > > I tried backtick, single quotes, doubles quotes. nothing appears to work. > > Thanks > Brent > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >