99网
您的当前位置:首页Operand should contain 1 column(s)

Operand should contain 1 column(s)

来源:99网

select (vid_id, vid_name, vid_leadrole, vid_desc,  vid_info, vinfo.cid, vid_serialstate)

       from tb_videoinfo vinfo  where vinfo.cid in (select cid from tb_category where pid=#{cid})

会报 Operand should contain 1 column(s) 错误: Operand should contain 1 column(s)

 

搜索一下,去掉红色的括号就Ok了,

select vid_id, vid_name, vid_leadrole, vid_desc, vid_info, vinfo.cid, vid_serialstate

       from tb_videoinfo vinfo  where vinfo.cid in (select cid from tb_category where pid=#{cid})

时间紧任务重,暂时没有事件去找根本原因了,先记录一下。

 

 

因篇幅问题不能全部显示,请点此查看更多更全内容