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
5903
April 04, 2005 04:13PM
Re: Show Triggers ?
4377
April 05, 2005 12:14AM
2670
April 05, 2005 08:25AM
2605
April 05, 2005 08:31AM
2149
April 05, 2005 09:11AM
2672
April 05, 2005 10:15AM
2558
June 26, 2005 11:27PM
2382
August 01, 2005 06:30AM
3998
August 01, 2005 07:41AM
2438
August 02, 2005 03:22AM
2498
August 02, 2005 11:04PM
2863
August 02, 2005 03:41AM
2524
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.