BY clause and contains nonaggregated column
我哪里错了？SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUPBY clause and contains nonaggregated column 'myapp.users.name&#x
浏览 1提问于2018-02-20得票数 0
user); });SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDERBY clause is not in GROUP BY clause and contains nonaggregated column
浏览 0提问于2018-10-11得票数 4
回答已采纳
我得到了以下错误：
Mysql2::Error: Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregatedcolumn 'database_name_development.posts.created_at' which is not functionally dependent on columns inGROUP B
浏览 3提问于2017-10-03得票数 1
回答已采纳
sql查询如下 SELECT `speciesname`, sum(`total_species_catch`) as species_catch FROM `species_estimation` GROUPby `speciesid` ORDER by `species_catch` DESC LIMIT 0,10 它在本地主机phpmyadmin中运行良好 在服务器中，它显示如下错误 SELECT listis not in GROUP BY clause and contains nona
浏览 16提问于2019-02-07得票数 1
回答已采纳
payments.customer_id, payments.dateWHERE reason like '%error%' 这是如果我试图使用组的错误信息
Expression #2 of SELECT list is not in GROUP BY clause and containsnonaggregated colu
浏览 0提问于2020-03-20得票数 0
回答已采纳
我试图在group_by()引擎中使用SQLAlchemy的mysql+mysqlconnector函数： .order_by(MyModel.published_date.desc()) \ .all()[42000][1055] Expression #1 of SELECT list is
浏览 0提问于2019-10-30得票数 1
回答已采纳
COUNT(*) AS orders, ROUND(SUM(total),2) AS total, MONTHNAME(created_at) AS MONTH AND YEAR(created_at) = YEAR(CURDATE()) ORDER BY created_atExpression #1 of ORDER BY clause is not in G
浏览 1提问于2017-10-04得票数 0
1回答
mobilehomes.community_id = 1) AND photos.image_file_size IS NOT NULL GROUP BY photoable_id Expression #1 of SELECT listis not in GROUP BY clause and contains
no
浏览 0提问于2018-04-23得票数 1
回答已采纳
code: 'ER_WRONG_FIELD_WITH_GROUP', sqlMessage: "Expression #1 of SELECT list is notin GROUP BY clause and contains nonaggregated column 'fashioncart.items.item_id' which is not functionallydependent on co
浏览 89提问于2019-12-24得票数 1
Connection.php line 770: ORDERBY clause is not in GROUP BY clause and contains nonaggregated
column 'device.devices.shipping_date' which is n
浏览 1提问于2017-04-27得票数 1
endOfMonth(), ]) ->order(['Transactions.created'=>'ASC']) }Synta
浏览 2提问于2021-09-02得票数 0
回答已采纳
(created_at,'%Y-%m') ORDER BY id DESC LIMIT 12;SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not inGROUP BY clause and contains n
浏览 6提问于2017-03-17得票数 0
收到以下错误：
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'world.country.Code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_fu
浏览 0提问于2016-01-21得票数 42
BY clause and contains nonaggregated column \'project.User.id\' which is not functionally dependenton columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by',
sql: 'SELECT`createdAt`, \
浏览 38提问于2019-02-20得票数 1
2回答
"visits": 10我在Laravel中的代码是： $ordersChart = Order但在返回$ordersChart后，显示以下错误：
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDERBY clause is not in GROUP BY clause an
浏览 0提问于2018-04-19得票数 0
SequelizeDatabaseError: ER_WRONG_FIELD_WITH_GROUP: Expression #2 of SELECT list is not in GROUP BY clauseand contains nonaggregated column 'assets.group_id' which is not functionally dependent on columns inGROUP BY <em
浏览 11提问于2016-03-09得票数 12
回答已采纳
我有这段代码，它在在线服务器上正常工作：DATE(`order`.`posted_date`)) AS `total_charge`GROUP BY YEAR(`dater`), MONTH(`dater`)但是，在本地主机上，它会出现如下错误：
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contai
浏览 3提问于2016-08-27得票数 1
回答已采纳
误差-> Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sephecom_ecom.v2.secondary_colors' which is not functionally dependent on columns in GROUP BY clause; this is incompatiblewith s
浏览 5提问于2019-05-31得票数 0
回答已采纳
JOIN Amenities ON Amenities.property_FK = Property.property_id ORDER
浏览 9提问于2022-07-23得票数 0
回答已采纳
.*, GROUP_CONCAT(ut.bet_group_id)WHERE ut.user_id = 3我的目标是group_concat bet_group_id by user_id，但是当我执行上面的查询时，我得到以下错误Expression #1 ofSELECT list is not in GROUP BY
浏览 7提问于2020-08-20得票数 0
回答已采纳
扫码
添加站长 进交流群
领取专属 10元无门槛券
手把手带您无忧上云
相关资讯
热门标签
云服务器
ICP备案
对象存储
实时音视频
即时通信 IM活动推荐
腾讯云开发者
