Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to achieve exception handling in MYSQL". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to achieve exception handling in MYSQL".

After rummaging through the MYSQL manual, I couldn't find which system variable saved the error code.

The following exception handling can catch an exception, but you don't know what it is, but you can find it in log

Of course, for specific SQL statements, you can also specify, such as primary key conflicts, rollback

DECLARE exit HANDLER FOR SQLSTATE '23000'

Delimiter / /

CREATE PROCEDURE TEST ()

BEGIN

DECLARE exit HANDLER FOR SQLEXCEPTION,SQLWARNING,NOT FOUND

Begin

Rollback

Insert into bb values ('error')

End

START TRANSACTION

INSERT INTO aa VALUES (1)

INSERT INTO aa VALUES (2)

COMMIT

END

/ /

CALL test () / /

The above is all the content of the article "how to implement exception handling in MYSQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.