Geek asks and answers

How to get exception message in stored procedure in MySQL 5.5

I am using MySQL 5.5.
To get an error message in MySQL 5.6, a function is used GET DIAGNOSTIC. Is there a similar feature in MySQL 5.5 ,.
The project I'm working on already uses MySQL version 5.5.

+5
source share
1 answer

You can try using SHOW ERRORand SHOW WARNING. To see the latest error or warning, you can use it as:

SHOW ERRORS LIMIT 1   -- for SQL-state > 2
SHOW WARNINGS LIMIT 1 -- for SQL-state 1,2

To prevent each error from being listed, you can handle the SQL error class:

SQLWARNING is a shorthand for a class of SQLSTATE values ​​that begin with '01'.

NOT FOUND - SQLSTATE, '02'. , , . , " " SQLSTATE 02000. , ( NOT FOUND). 12.7.5, "". SELECT... INTO var_list, .

SQLEXCEPTION SQLSTATE, "00", "01" "02".

, , :

DECLARE EXIT HANDLER FOR SQLSTATE SQLEXCEPTION .....;

:

http://dev.mysql.com/doc/refman/5.5/en/signal.html

http://dev.mysql.com/doc/refman/5.0/en/declare-handler.html

+4

More articles:


All Articles