Subquery returns more than 1 row
表示子查询返回了多行数据
例如:
select * from user where username='xiaoqing' and (select U_id from user where username='xiaoqing')=(select student_id from student where student_classid='20210504')
这里是因为等号右侧查询有多条符合的数据
解决方法:
select * from user where username='xiaoqing' and (select U_id from user where username='xiaoqing')=any(select student_id from student where student_classid='20210504')
在等号右侧的查询前添加any
添加后的运行结果: