更新时间:2022-10-14 20:07:43
This
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'returntr_prod.tbl_customer_pod_uploads.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
will be simply solved by changing the sql mode in MySQL by this command,
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
This is too works me.. I used this becz in my project there are many Queries like this so just change this sql mode onli_full_group_by
ThanQ... :-)
SELECT列表不在GROUP BY子句中,并且包含非聚集列....与sql_mode = only_full_group_by不兼容
错误 1055 (42000):SELECT 列表的表达式 #1 不在 GROUP BY 子句中......这与 sql_mode=only_full_group_by 不兼容
#1055-SELECT列表的表达式不在GROUP BY子句中,并且包含未聚合的列,这与sql_mode = only_full_group_by不兼容
SELECT 列表不在 GROUP BY 子句中并且包含非聚合列 .... 与 sql_mode=only_full_group_by 不兼容
SELECT 列表不在 GROUP BY 子句中并且包含非聚合列......与 sql_mode=only_full_group_by 不兼容
#1055 - SELECT 列表的表达式不在 GROUP BY 子句中,并且包含与 sql_mode=only_full_group_by 不兼容的非聚合列