![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
文章平均质量分 54
娜些时光(*^▽^*)
这个作者很懒,什么都没留下…
展开
-
mysql使用DISTINCT函数,报错ERROR 1140 (42000): In aggregated query without GROUP BY.....
现象:执行sqlSELECT COUNT(DISTINCT ( colum1 )),colum2, colum3 FROM table;报错ERROR 1140 (42000): In aggregated query without GROUP BY.....原因:mysql的sql_mode默认开启了only_full_group_by模式,导致mysql的sql的group ...原创 2020-03-25 11:56:57 · 1856 阅读 · 0 评论 -
Mysql遇到错误总结
在我同时使用order by 和union 时报错Incorrect usage of UNION and ORDER BY展示错误sqlSELECT ilcd.rfidStatus,ilcd.rfidSN as rfieSn from i_locker_communication ilcLEFT JOIN i_locker_communication_detail ilcd on i...原创 2019-11-07 11:27:58 · 155 阅读 · 0 评论