分类目录归档:Mysql-Error

[ msyql异常 ]


1. group by语句问题

问题:

SQL 错误 [1055] [42000]: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pymysql.users.password' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决:

ONLY_FUL

< Read more >