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
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
thinking if the CREATE DATABASE and
Try the documentation.
http://mysql.com/triggers
sends you to
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
from there you can click on "CREATE TRIGGER SYNTAX"
to get to
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
which clearly shows that syntax is not valid.
Alternatively,
Hi,
Sorry if I wasn't very clear with my question. I was hoping to obtain
the functionality such that I could do something similar to:
CREATE TRIGGER IF NOT EXISTS
Because I usually get a trigger already exists in my script. I might be
missing something.
The script basically does the
There is a TRIGGERS table in the information_schema
Eg.
select Trigger_Name from TRIGGERS
where trigger_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: