Operand should contain 1 column(s)

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})

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