最后一個指令跑不了 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.p.type_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
?Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.p.type_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
2019-07-09
第三頁有個關于group by的解答
2019-06-14
group by 的列 要么必須出現在 select 的查找列中，要么必須是以聚合函數的形式使用
2019-06-14
在mysql的配置文件下my.ini中的[mysqld]下加入
sql-mode=
"STRICT_TRANS_TABLES,NO_ZERO_IN_DATE，NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
如果原來有sql -mode=...就把原來的用#注釋掉
,