为何对空表 select count(*)返回 1 ？
mysql> select * from t_black_user_;
Empty set (0.00 sec)
mysql> SELECT COUNT(*) from t_black_user_;
+---------------+
| t_black_user_ |
+---------------+
| 1 |
+---------------+
1 row in set (0.00 sec)
This topic created in 3127 days ago, the information mentioned may be changed or developed.
 |
1
zk8802 Oct 19, 2017 via iPhone
应该是 select count(*) from t_black_user_;
|
|
2
zk8802 Oct 19, 2017 via iPhone
|
 |
4
zgx030030 Oct 19, 2017
为什么感觉你结果中 “ 1 ”的上面的字段名应该是“ COUNT(*)” ， 你的为什么是表名？
|
 |
5
chenset Oct 19, 2017
会不会是非同一个 transaction 或者 session. 没 commit 或者 rollback
|
Select Language