?

具體報錯

[2019-02-20 11:57:36] [42000][1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'exer.student.sid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

?

?解決方案

select version(), @@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

?

?

show variables like "sql_mode"; set sql_mode=''; set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

?

轉載于:https://www.cnblogs.com/shijieli/p/10405795.html

總結

以上是生活随笔為你收集整理的MySQL 报错 1055的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。