error on dropping trigger
Hi everybody,
I was doing some changes on our product's database, and I issued a query
DROP TRIGGER IF EXISTS task_log_insert;
and it fails with ERROR 1360 (HY000): Trigger does not exist
why do I get the error considering that I used the "if exists" clause?
We are currently using MySQL 5.1.42 on Windows 7 Professional 32bit.
Subject
Views
Written By
Posted
error on dropping trigger
5763
May 17, 2011 06:44AM
2067
May 17, 2011 07:37AM
2002
May 17, 2011 09:53AM
1679
May 18, 2011 01:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.