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 CREATE TABLE have a IF NOT EXISTS
functionality, why should the triggers be any different? Maybe this is
just an oversight, maybe the CREATE TRIGGER should have a IF NOT EXISTS
functionality also? or I'm just doing something very wrong.
Maybe someone can point me in the right direction?
sheeri kritzer wrote:
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, you could try it yourself and see that it fails.
-Sheeri
On 4/7/06, Adrian Co <[EMAIL PROTECTED]> wrote:
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 basic things like create database if not
exists, create table if not exists, etc. I was hoping the same thing for
triggers maybe? Is this possible?
Regards,
Adrian Co
Jim wrote:
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: 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]