Adrian Co wrote:
> Hi,
>
> Yes, the syntax is not valid. I have tried it. :-)
>
> I was hoping for maybe a workaround to simulate the described
> functionality. There might also be something wrong with the structure of
> my script. Maybe I shouldn't be creating triggers there? But I was
> thinki
day, 7 April 2006 1:54 PM
To: mysql@lists.mysql.com
Subject: Determining if a trigger exists
Hi,
Whats the simplest way to determine if a trigger already exists?
i.e. For tables you have: CREATE TABLE IF NOT EXISTS ...
Is there a way to do
CREATE TRIGGER IF NOT EXISTS
I'm using MySQL 5.0 bt
ROPLINK'
> >
> >
> >-Original Message-
> >From: Adrian Co [mailto:[EMAIL PROTECTED]
> >Sent: Friday, 7 April 2006 1:54 PM
> >To: mysql@lists.mysql.com
> >Subject: Determining if a trigger exists
> >
> >Hi,
> >
> >Whats the
_name = 'TI_AGENT' AND trigger_schema = 'PROPLINK'
-Original Message-
From: Adrian Co [mailto:[EMAIL PROTECTED]
Sent: Friday, 7 April 2006 1:54 PM
To: mysql@lists.mysql.com
Subject: Determining if a trigger exists
Hi,
Whats the simplest way to determine if a trigger
ts.mysql.com
Subject: Determining if a trigger exists
Hi,
Whats the simplest way to determine if a trigger already exists?
i.e. For tables you have: CREATE TABLE IF NOT EXISTS ...
Is there a way to do
CREATE TRIGGER IF NOT EXISTS
I'm using MySQL 5.0 btw.
Thanks!
Regards,
Adrian
--
M
Hi,
Whats the simplest way to determine if a trigger already exists?
i.e. For tables you have: CREATE TABLE IF NOT EXISTS ...
Is there a way to do
CREATE TRIGGER IF NOT EXISTS
I'm using MySQL 5.0 btw.
Thanks!
Regards,
Adrian
--
MySQL General Mailing List
For list archives: http://lists.mys
