Skip navigation links

MySQL Forums :: Triggers :: How to DEBUG a trigger or procedure


Advanced Search

Re: How to DEBUG a trigger or procedure
Posted by: Bob Field ()
Date: March 24, 2006 09:16AM

Just add SELECT statements:

SELECT 'Message Text' AS `Title`;

Or create a temporary table and insert messages into it. SELECT * from temptable at the end of your procdure or after you're back at the prompt.



Edited 1 time(s). Last edit at 03/24/2006 09:18AM by Bob Field.

Options: ReplyQuote


Subject Views Written By Posted
How to DEBUG a trigger or procedure 27972 PavanKumarGupta Pinnu 03/24/2006 04:08AM
Re: How to DEBUG a trigger or procedure 21132 Bob Field 03/24/2006 09:16AM
Re: How to DEBUG a trigger or procedure 16232 Faisal Siddiqui 06/08/2007 08:30AM


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.