且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SELECT列表不在GROUP BY子句中,并且包含非聚集列....与sql_mode = only_full_group_by不兼容

更新时间: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... :-)

相关阅读

技术问答最新文章