mysql 查询返回码

Question

我正在编写一个 MYSQL 存储过程。我知道使用 HANDLER 我们可以检查 SELECT 语句的条件。

DECLARE CONTINUE HANDLER FOR NOT FOUND
SET  NO_MORE_ROWS = TRUE;

在 DB2 中，我们可以在语句之后立即使用 SQLCODE 检查返回代码。

请让我知道我需要如何处理重复索引、多行、游标问题、源变量与表字段的数据不匹配。 MYSQL有没有办法。

基本上我想知道在MYSQL中如何处理以下情况。

  SELECT  -  NOT FOUND, MORE THAN ONE ROW, EXCEPTION, DATATYPE MISMATCH IN TO CONDITION
  INSERT  -  DUPLICATE INDEX, DATATYPE MISMATCH, OTHER INERT FAILURE
  UPDATE  -  NO DATA FOR UPDATE, UPDATE WHERE CONDITION NOT MET
  DELETE  -  NOT DELETED BECAUSE OF FOREIGN KEY ISSUE.
  CURSOR  -  CURSOR FAILURE

谢谢。

Answer 1

如 DECLARE ... HANDLER Syntax 下所述:

The condition_value for DECLARE ... HANDLER indicates the specific condition or class of conditions that activates the handler:

• A MySQL error code (a number) or an SQLSTATE value (a 5-character string literal). You should not use MySQL error code 0 or SQLSTATE values that begin with '00', because those indicate success rather than an error condition. For a list of MySQL error codes and SQLSTATE values, see Section C.3, “Server Error Codes and Messages”.