例如：

select * from user_facility where user_id = 60040012 and facility_id = (select facility_id from scene_facility_room where room_id = 5);

會報錯 Subquery returns more than 1 row

原因：

因為使用的字段使用的=，只符合select語句只查出一條記錄的情況。
如果查出的記錄是多條記錄，這時上述語句會報Subquery returns more than 1 row

解決：

有兩種方法

語句中的 = 換成 in，如下：

select * from user_facility where user_id = 60040012 and facility_id in (select facility_id from scene_facility_room where room_id = 5);

語句中 = 后面加 any，如下：

select * from user_facility where user_id = 60040012 and facility_id = any (select facility_id from scene_facility_room where room_id = 5);

總結

以上是生活随笔為你收集整理的MySQL---Subquery returns more than 1 row的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。