mysql return more than 1 row_mysql连表查询报错：Subquery returns more than 1 row

最新推荐文章于 2023-12-20 19:13:32 发布

墙角的吉他

最新推荐文章于 2023-12-20 19:13:32 发布

阅读量292

点赞数

文章标签： mysql return more than 1 row

本文链接：https://blog.csdn.net/weixin_36481059/article/details/114755967

版权

意思是查询的数据不能多余一行，多余一行就会报错。

解决方法：

1、需要在语句后面加上limit 1

比如：

SELECT `kid_id` FROM `tl_player` WHERE `id`=(SELECT `player_id` FROM `tl_player_travel_user_city` WHERE `city_id`=1 AND `status`=2) limt 1

2、在子查询前加any关键字

比如：

SELECT * FROM `tl_order` WHERE `member_id`=any(SELECT `member_id` FROM `tl_kid` WHERE `id`=any(SELECT `kid_id` FROM `tl_player` WHERE `id`=any(SELECT `player_id` FROM `tl_player_travel_user_city` WHERE `city_id`=1 AND `status`=2))) AND (`goods_id`=123 or `goods_id`=13) AND `status`=0

第一种方法适合只需要查询一条数据的情况

第二种方式适合查询多条符合条件的情况