On Thu, 30 Jun 2005, Jigal van Hemert wrote:
> MySQL is correct here: the syntax is
> drop trigger <tablename>.<triggername>;
> http://dev.mysql.com/doc/mysql/en/drop-trigger.html
Ah, that explains a lot. I just read tablename as database because of
all the other syntax. Works now.
Does anybody now when MySQL plans to support direct references to
table names? (From the docs:
"Note: Currently, triggers have the same limitation as stored functions
that they may not contain direct references to tables by name. This
limitation will be lifted as soon as possible.)
--
patrik_wallstrom->foodfight->[EMAIL PROTECTED]>+46-733173956
`-> http://www.gnuheter.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
