mysql no data found_错误解决mysql - Event Scheduler: No data - zero rows fetched, selected, or processed...

最新推荐文章于 2023-12-25 02:30:30 发布

80 seconds

最新推荐文章于 2023-12-25 02:30:30 发布

阅读量563

点赞数

文章标签： mysql no data found

本文链接：https://blog.csdn.net/weixin_42153615/article/details/113909279

版权

本文介绍了解决MySQL中NOTFOUND警告问题的方法，尤其是在5.6.3版本之后，如何通过在条件句柄中加入成功查询来确保警告区域被清理，避免误判。教程详细讲解了创建包含清除警告的CONTINUE HANDLER的存储过程示例。

摘要由CSDN通过智能技术生成

当遇到一个NOT FOUND(无数据)的警告时，使用一个包含清除警告语句的条件句柄处理，就可以继续处理程序并退出句柄。

这个问题在MySQL5.6.3之后的版本已经解决了，所以该解决方法不是必要的。

解决方法：

DECLARE CONTINUE HANDLER FOR NOT FOUND

BEGIN

SET done=1

SELECT 1 INTO @handler_invoked FROM (SELECT 1) AS t;

END;

来源：Click the link(http://dev.mysql.com/doc/refman/5.5/en/condition-handling.html) and scroll to the bottom for details but the fix was to include a successful select INSIDE the CONTINUE HANDLER:

原文：

Before MySQL 5.6.3, if a statement that generates a warning or error causes a condition handler to be invoked, the handler may not clear the diagnostic area. This might lead to the appearance that the handler was not invoked. The following discussion demonstrates the issue and provides a workaround.

Suppose that a table t1 is empty. The following procedure selects from it, raising a No Data condition:

CREATE PROCEDURE p1()

BEGIN

DECLARE a INT;

DECLARE CONTINUE HANDLER FOR NOT FOUND

BEGIN

SET @handler_invoked = 1;

END;

SELECT c1 INTO a FROM t1;

END;

As can be seen from the following sequence of statements, the condition is not cleared by handler invocation (otherwise, the SHOW WARNINGS output would be empty). But as can be seen by the value of @handler_invoked, the handler was indeed invoked (otherwise its value would be 0).

mysql> SET @handler_invoked = 0;

Query OK, 0 rows affected (0.00 sec)

mysql> CALL p1();

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;

+---------+------+-----------------------------------------------------+

| Level | Code | Message |

+---------+------+-----------------------------------------------------+

| Warning | 1329 | No data - zero rows fetched, selected, or processed |

+---------+------+-----------------------------------------------------+

1 row in set (0.00 sec)

mysql> SELECT @handler_invoked;