数据库错误 ERROR 1366 (HY000) Incorrect string value 'xD4xF8xBBxAA' for column 'Sname' at row 1解决.md

数据库错误 ERROR 1366 (HY000): Incorrect string value: '\xD4\xF8\xBB\xAA' for column 'Sname' at row 1解决一.原因:插入数据时有中文字符出现二.解决方案1.查看当前服务器状态 : status或者\s2.修改数

In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column

ERROR 1140 (42000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'mydb.student.sname'; this is inc