MySQL Forums
Forum List  »  Triggers

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

Written By
Re: How to DEBUG a trigger or procedure
March 24, 2006 09:16AM

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.