wdeipeng的博客

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...

查询出来的只有IN里面的第一个值，因为IN里面的SQL查询出来的是字符串SELECTGROUP_CONCAT(c2.id) AS ids,GROUP_CONCAT(c2. NAME) AS NAMESFROMls_category c2WHEREc2.id IN (SELECTc1.all_parent_idFROMls_category c1WHEREc1.id = 5...