MySQL Forums :: Stored Procedures :: sqlcode in mysql?


Advanced Search

Re: sqlcode in mysql?
Posted by: Peter Brawley ()
Date: November 30, 2009 11:10AM

In MySQL 5, sproc error handling is by ...

DECLARE error_condition_name CONDITION FOR
SQLSTATE [VALUE] sqlstate_value | mysql_error_code

DECLARE CONTINUE | EXIT | UNDO HANDLER FOR SQLSTATE [VALUE] sqlstate_value | error_condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION | MySQL error code

See the manual page for DECLARE HANDLER

MySQL 5.5 or 6.0 (we do not know which will be its version number) will implement the ISO SQL standard SIGNAL and RESIGNAL.

PB
http://www.artfulsoftware.com

Options: ReplyQuote


Subject Views Written By Posted
sqlcode in mysql? 2628 sy l 11/18/2009 04:34AM
Re: sqlcode in mysql? 1892 Devart Team 11/18/2009 05:36AM
Re: sqlcode in mysql? 1461 sy l 11/26/2009 08:21PM
Re: sqlcode in mysql? 1385 Peter Brawley 11/26/2009 08:29PM
Re: sqlcode in mysql? 1442 sy l 11/27/2009 04:48AM
Re: sqlcode in mysql? 1543 Peter Brawley 11/27/2009 09:36AM
Re: sqlcode in mysql? 1573 sy l 11/27/2009 07:10PM
Re: sqlcode in mysql? 1339 Peter Brawley 11/27/2009 10:14PM
Re: sqlcode in mysql? 1504 sy l 11/28/2009 12:39PM
Re: sqlcode in mysql? 1235 Peter Brawley 11/28/2009 03:03PM
Re: sqlcode in mysql? 1311 sy l 11/30/2009 03:08AM
Re: sqlcode in mysql? 1755 Peter Brawley 11/30/2009 11:10AM
Re: sqlcode in mysql? 1340 sy l 12/03/2009 01:26AM
Re: sqlcode in mysql? 1445 Peter Brawley 12/03/2009 03:12AM


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.