SQLSTATE[42000]: Syntax error or access violation: 1055 Expr

2021-04-02 09:10 jianzhan

郑州市高档网站设计制作开发设计网站全过程中,碰到SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column shopjiutongwang.up.user_price which is not functionally dependent on columns in GROUP BY clause; this patible with sql_mode=only_full_group_by。这一提醒

出現这类难题 f 就可以

在mysqld下边加上sql_mode= 随后储存 -》重新启动mysql 完活