Re: sqlcode in mysql?
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
Subject
Views
Written By
Posted
4210
November 18, 2009 04:34AM
2650
November 18, 2009 05:36AM
2139
November 26, 2009 08:21PM
1929
November 26, 2009 08:29PM
1987
November 27, 2009 04:48AM
2264
November 27, 2009 09:36AM
2154
November 27, 2009 07:10PM
1871
November 27, 2009 10:14PM
2423
November 28, 2009 12:39PM
1792
November 28, 2009 03:03PM
1798
November 30, 2009 03:08AM
Re: sqlcode in mysql?
2616
November 30, 2009 11:10AM
3751
December 03, 2009 01:26AM
2079
December 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.