mysql报错
郝小祺
初级博客,很希望交到一些一起成长的盆友们
展开
-
完美解决(报错 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated)
很简单的东西我整复杂了, 我的是因为mysql没有走my.ini放一下我的my.ini[mysqld]character-set-server=utf8#绑定IPv4和3306端口bind-address = 0.0.0.0port = 3306sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"default_storage_engine=innodbinnodb_buffer_pool_size=1000Minnodb_l.原创 2020-09-15 11:41:51 · 1443 阅读 · 0 评论 -
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF
ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROF:错误是从这里开始的,我百度了一下,有两种解决办法1. 打开mysql查询命令输入 select version(), @@sql_mode;//这个是查看你配置的SET sql_mod...原创 2020-01-03 11:29:56 · 1118 阅读 · 1 评论