关于数据库操作问题

173 阅读1分钟

使用数据库数据查询的时候出现下列问题:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP

MySQL8.0.2 语句如下: select user_id, user_name from t_user group by user_id;

解决方法参考地址:

blog.csdn.net/marswill/ar…

www.jianshu.com/p/bb31e34c8…