w88高端网站定制开发网站过程中，遇到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 is incompatible with sql_mode=only_full_group_by。这个提示
出现这种问题 直接修改my.cnf 即可
在mysqld下面添加sql_mode="" 然后保存 -》重启mysql 完活
