Shulou(Shulou.com)06/01 Report--

This article is to share with you about how to solve errors in mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mysql error handling methods: 1, if a 1062 error occurs, execute the SELECT statement; 2, when the SQL selection statement does not return a value, set [l_done=1] to continue execution; 3, generate an error message and exit the current block or stored procedure; 4, if any error, set [l_error] to 1 before execution.

How to handle an error in mysql:

1. If there are any errors (not NOT FOUND), set l_error to 1 and continue:

DECLARE CONTINUE HANDLER FOR SQLEXCEPTIONSET l_error=1

2. If any error occurs (not NOT FOUND), execute ROLLBACK and generate an error message before exiting the current block or stored procedure.

DECLARE EXIT HANDLER FOR SQLEXCEPTIONBEGINROLLBACK;SELECT 'Error occurred-terminating';END

3. If the MySQL 1062 error (duplicate health value) occurs, execute the SELECT statement (send a message to the caller) and continue execution

DECLARE CONTINUE HANDER FOR 1062SELECT 'Duplicate key in index'

4. If a SQLSTATE 2300 error (duplicate health value) occurs, execute the SELECT statement (send a message to the caller) and continue execution

DECLARE CONTINUE HANDER FOR SQLSTATE '23000'SELECT' Duplicate key in index'

5. When the cursor or SQL selection statement does not return a value, set l_done=1 and continue execution

DECLARE CONTINUE HANDLER FOR NOTFOUNDSET l_done=1

6. This example is the same as the previous example, except that it uses a SQLSTATE variable instead of a naming condition

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET l_done=1

7. This example is the same as the previous two examples, except that the error code variable of MySQL is used instead of naming condition or SQLSTATE variable

Thank you for reading DECLARE CONTINUE HANDLER FOR 1329SET. About how to solve the mistakes in mysql to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.