摘要:
在使用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 閱讀全文