List:General Discussion« Previous MessageNext Message »
From:Patrik Wallstrom Date:June 30 2005 2:35pm
Subject:Re: drop trigger?
View as plain text  
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->pawal@stripped>+46-733173956
                `-> http://www.gnuheter.com/
Thread
drop trigger?Patrik Wallstrom30 Jun
  • Re: drop trigger?Jeff Smelser30 Jun
  • Re: drop trigger?Jigal van Hemert30 Jun
    • Re: drop trigger?Patrik Wallstrom30 Jun
  • Re: drop trigger?Gleb Paharenko30 Jun