show warning之后出现这个是什么意思 ERROR 1329 : No data - zero rows fetched, selected, or processed 程序运行正常 , 为什么要报0行接收, 查询 .. .
sql mode 是什么 mysql> show variables like '%sql_mode%'; +---------------+--------------------------------------------------------------- -+ | Variable_name | Value | +---------------+--------------------------------------------------------------- -+ | sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +---------------+--------------------------------------------------------------- -+ 1 row in set (0.00 sec)
I'm not an expert in MySQL 5, but i also know how the PL/SQL for oracle works to avoid zero rows fetched. It is not eficient but to minimize unknown bugs. Of coz the result would be NO result or YES result, and No data - zero rows fetched will be thrown if NO result.查到这样的资料, 原来做了一个查询, 查不到结果, 所以返回这样的警告, 是sql一个小bug.
mysql>show warning
可以看到是什么错误信息
ERROR 1329 : No data - zero rows fetched, selected, or processed 程序运行正常 , 为什么要报0行接收, 查询 .. .
mysql> show variables like '%sql_mode%';
+---------------+---------------------------------------------------------------
-+
| Variable_name | Value
|
+---------------+---------------------------------------------------------------
-+
| sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
|
+---------------+---------------------------------------------------------------
-+
1 row in set (0.00 sec)
Of coz the result would be NO result or YES result, and No data - zero rows fetched will be thrown if NO result.查到这样的资料, 原来做了一个查询, 查不到结果, 所以返回这样的警告, 是sql一个小bug.
我的SELECT语句查不到结果所以有这样一个warning, 但没结果是本身程序的一部份
php版块的, 广告又多 , 灌水也多, 问题也杂!