今天遇到了1055错误,在本机上程序是可以用的,可是在服务器上就出错了,错误入下:
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'XXXXXX' which is not functionally dependent on columns in GROUP BY clause; this is incompatible
今天遇到了1055错误,在本机上程序是可以用的,可是在服务器上就出错了,错误入下:
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'XXXXXX' which is not functionally dependent on columns in GROUP BY clause; this is incompatible