Operand should contain 1 column(s)

红太狼 2021-11-09 12:50 311阅读 0赞

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

  1. 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

  1. from tb\_videoinfo vinfo where vinfo.cid in (select cid from tb\_category where pid=\#\{cid\})

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

发表评论

表情:
评论列表 (有 0 条评论,311人围观)

还没有评论,来说两句吧...

相关阅读