![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
鹏羽
不拼怎么有将来
展开
-
linux中解决mysql语句group by查询
linux中解决mysql的 this is incompatible with sql_mode=only_full_group_by 报的错误如下: 解决方案: set @@GLOBAL.sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USE...原创 2019-09-20 09:55:39 · 485 阅读 · 0 评论 -
in改用find_in_set解决子查询字符串问题
查询出来的只有IN里面的第一个值,因为IN里面的SQL查询出来的是字符串 SELECT GROUP_CONCAT(c2.id) AS ids, GROUP_CONCAT(c2. NAME) AS NAMES FROM ls_category c2 WHERE c2.id IN ( SELECT c1.all_parent_id FROM ls_category c1 WHERE c1.id = 5...原创 2019-09-20 10:07:15 · 1603 阅读 · 0 评论