Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'a_id' which is not functionally
dependent on columns in GROUP BY clause;this is incompatible with sql_mode=only_full_group_by
解決方案
- 先使用 SQL 查詢
select @@global.sql_mode
- 此時去掉ONLY_FULL_GROUP_BY,然後重新設定值(引号中填寫裁剪後的字元串)
set @@global.sql_mode='';
查出來的值如下
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
本文來自部落格園,作者:不二橘子醬,轉載請注明原文連結:https://www.cnblogs.com/marmaladeHY/p/15669274.html