mysql 获取异常信息,在程序MySQL 5.5.x中获取SQLEXCEPTION消息

How can I get error text in MySQL 5.5 stored procedure when SQLEXCEPTION occurs?

I need something along these lines to see what went wrong:

DECLARE EXIT HANDLER FOR SQLEXCEPTION

BEGIN

GET DIAGNOSTICS CONDITION 1

SELECT "Table @p5 (Msg State @p2): @p1"

END;

Similar to Getting SQLEXCEPTION message in MySQL procedures, but there the Version was 5.6.4 - so GET DIAGNOSTICS was available.

解决方案

As I know, there is no way to emulate or replace the functionality of GET DIAGNOSTICS in lower versions of MySQL (lower than 5.6.4).

There are many entries on bugs.mysql.com and on MySQL forums which asks this feature. (Lke this one: http://bugs.mysql.com/bug.php?id=11660)

I do not know that you can or can not upgrade your MySQL instance, but as I know, this is your only chance.

I found (possibly you found them too) some questions related to this one, but all of them are either talking about version 5.6.4 or there are no answers:

EDIT

If you can, handle the MySQL errors in the client application.

You can list the errors and warnings with SHOW ERRORS and SHOW WARNINGS statements outside of the HANDLERs, but you can not insert the result of those statements into a table. Inside the handler, those statements will give empty resultset.

For specific states, you can declare individual handlers. This way, you could know the state, but you do not know any other details.