摘要:
在使用GROUP BY对Mysql的数据表进行查询时如果出现以下错误 ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'playe 阅读全文
摘要:
1、只要修改一下表的字符集,如下: ALTER TABLE users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 1 2、 将比较等式一边进行字符串转换,如改为“CONVERT(b.fullCode USING utf8) COLL 阅读全文