mysql error1241:Operand should contain 1 column(s)
答案:1 悬赏:0
解决时间 2021-03-02 11:39
- 提问者网友：棒棒糖
- 2021-03-01 12:05
mysql error1241:Operand should contain 1 column(s)
最佳答案
- 二级知识专家网友：神也偏爱
- 2021-03-01 13:22
mysql error1241:Operand shou--根据报错来看 ，你下面的一个查询返回了两个值cou_name as 最优秀课程,sco_score as 成绩
--Operand should contain 1 column(s)
(select cou_name as 最优秀课程,sco_score as 成绩 from cou,sco where cou.cou_id=sco.cou_id group by stu_id having sco_score=max(sco_score)),
(select cou_name as 最差课程,sco_score as 成绩 from cou,sco where cou.cou_id=sco.cou_id group by stu_id having sco_score=min(sco_score)),ld contain 1 column(s)
--Operand should contain 1 column(s)
(select cou_name as 最优秀课程,sco_score as 成绩 from cou,sco where cou.cou_id=sco.cou_id group by stu_id having sco_score=max(sco_score)),
(select cou_name as 最差课程,sco_score as 成绩 from cou,sco where cou.cou_id=sco.cou_id group by stu_id having sco_score=min(sco_score)),ld contain 1 column(s)
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯