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>;

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.)

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