聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
使用DISTINCT語(yǔ)句報(bào)錯(cuò)時(shí):
Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT
問(wèn)題原因:mysql5.7.5及以上版本將sql_mode的ONLY_FULL_GROUP_BY模式默認(rèn)設(shè)置為打開(kāi)狀態(tài),會(huì)導(dǎo)致一些錯(cuò)誤
解決方案:
通過(guò)修改mysql的配置文件my.ini,關(guān)閉ONLY_FULL_GROUP_BY SQL模式
文件底部追加:
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION