Re: Select Statement in Trigger

[Devaraya K]

Hi Andrew,

I am using mysql 5.0.15nt version.

when i am creating trigger with
mysql> create trigger database name.trigger name ........

error 1359 (HY000): Trigger already exits

I executed the command to see all the triggers attached to the database.

mysql> select trigger_name from information_schema.triggers where trigger_schema='database name';

there is no trigger in the list


Devaraya