MySQL Forums
Forum List  »  Triggers

Re: Show Triggers ?
Posted by: Andrew Gilfrin
Date: April 05, 2005 12:14AM

Peter

You have highlighted something which is a problem in the current MySQL trigger implementation. There are currently no show or information schema details for triggers. MySQL have said this will be addresses in future versions.

This is a problem becasue MYSQL limits you to a single trigger type per table so if you create one but forget the name there is no easy way to get rid of it.

My personal solution is to use a naming convention that will at least give you the option of removing the trigger. If you don't know the names then your only course of action would be to drop and recreate the table the trigger is on.

There is some discussion on my site about using a naming convention and solutions to the current problems, you can access the page here http://mysql.gilfster.com/triggers/creating.php there is also plenty of other information on MySQL Triggers.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
6244
April 04, 2005 04:13PM
Re: Show Triggers ?
4630
April 05, 2005 12:14AM
2821
April 05, 2005 08:25AM
2753
April 05, 2005 08:31AM
2318
April 05, 2005 09:11AM
2823
April 05, 2005 10:15AM
2700
June 26, 2005 11:27PM
2522
August 01, 2005 06:30AM
4149
August 01, 2005 07:41AM
2583
August 02, 2005 03:22AM
2645
August 02, 2005 11:04PM
3085
August 02, 2005 03:41AM
2688
August 02, 2005 04:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.