From: Andrew Moore
Date: February 21 2012 1:22am
Subject: Re:Cant drop trigger.
List-Archive: http://lists.mysql.com/mysql/226826
Message-Id: <CAGTTpyhRLmC+pL7aKsRDu4xJV3xjCxbmrfAe1beFFHVMEYqDfQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=e89a8f50320cf5ab0604b96f3ca5

--e89a8f50320cf5ab0604b96f3ca5
Content-Type: text/plain; charset=ISO-8859-1

Is there white space at the end of the trigger name?

A
On Feb 20, 2012 10:04 PM, "Brent Clark" <brentgclarklist@stripped> 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
>
>

--e89a8f50320cf5ab0604b96f3ca5--