为什么这条语句查询结果会显示不全?
mysql> SELECT DISTINCT username,password,email FROM t_u_e_p_csdn_net WHERE username LIKE 'sbboy' OR email LIKE 'sbboy@%';
+----------+----------+-------------------+
| username | password | email |
+----------+----------+-------------------+
|sbboy | 19890101 | sbsqqboy@163.com
+----------+----------+-------------------+
1 row in set (0.00 sec)
mysql> SELECT DISTINCT username,email,password FROM t_u_e_p_csdn_net WHERE username LIKE 'sbboy' OR email LIKE 'sbboy@%';
+----------+-------------------+----------+
| username | email | password |
+----------+-------------------+----------+
| 19890101 |sbsqqboy@163.com
+----------+-------------------+----------+
1 row in set (0.00 sec)
补充个表结构。。
t_u_e_p_csdn_net | CREATE TABLE `t_u_e_p_csdn_net` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL DEFAULT '',
`email` varchar(32) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `email` (`email`),
KEY `username` (`username`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=12599950 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
只是交换了一下password的位置,为何这两次查询的结果会是这个样子?
再次补充,不用DISTINCT也是这样的
mysql> SELECT username,password,email FROM t_u_e_p_csdn_net WHERE username LIKE
'sbboy' OR email LIKE 'sbboy@%';
+----------+----------+-------------------+
| username | password | email |
+----------+----------+-------------------+
|sbboy | 19890101 | sbsqqboy@163.com
+----------+----------+-------------------+
1 row in set (0.00 sec)
mysql> SELECT username,email,password FROM t_u_e_p_csdn_net WHERE username LIKE
'sbboy' OR email LIKE 'sbboy@%';
+----------+-------------------+----------+
| username | email | password |
+----------+-------------------+----------+
| 19890101 |sbsqqboy@163.com
+----------+-------------------+----------+
1 row in set (0.00 sec)
--------------------------------------------------------
再次补充 ,username = 也没用
mysql> SELECT DISTINCT username,email,password FROM t_u_e_p_csdn_net WHERE usern
ame = 'sbboy' OR email LIKE 'sbboy@%';
+----------+-------------------+----------+
| username | email | password |
+----------+-------------------+----------+
| 19890101 |sbsqqboy@163.com
+----------+-------------------+----------+
1 row in set (0.01 sec)
mysql> SELECT username,email,password FROM t_u_e_p_csdn_net WHERE username = 'sb
boy' OR email LIKE 'sbboy@%';
+----------+-------------------+----------+
| username | email | password |
+----------+-------------------+----------+
| 19890101 |sbsqqboy@163.com
+----------+-------------------+----------+
1 row in set (0.00 sec)
相关阅读:
IE6在iframe中使用appendchild,报错误“参数错误
现在有支持nodejs的富文本编辑器吗?
wamp环境如何给php7配置mssql扩展?
跨平台同步数据效率最高的解决方案是什么?
border怎么形成的
关于IE6兼容性问题?
请教两个提高vim使用效率的问题
OC 与JS 交互,回调。
iOS 接入友盟的微博第三方登录,确认界面马上消失不能点击确认按钮!!!
谁告诉我下 . PHP 中 phardata.buildfromdirectory 这个是干啥的 ?
如何用js阻止后续的javascript标签的载入?
angular2 用函数返回值设置图片的问题
一道小面试题
像这样的sql语句,mysql编译几次
hadoop 源码是用什么语言写的?
如何获得 Flask 项目所有的视图极其对应的 route
java 使用 poi 生成excel ,打开excel后,滚动条默认滚动到最右边
网页上如何检测处于离线状态?
使用PHP保存图片同时保持源来图片的md5值
SublimeText 求插件支持php跳转到require include包含的文件?