SQL查询字段添加括号报错：Operand should contain 1 column(s)

 

select (vid_id, vid_name, vid_leadrole, vid_desc, vid_director, vid_date,  vid_area, vid_pic, vid_score, vid_info, vinfo.cid, vid_serialstate)
 from tb_videoinfo vinfo  where vinfo.cid in (select cid from tb_category where pid=#{cid})

===================================================
把select后面的括号去掉

select vid_id, vid_name, vid_leadrole, vid_desc, vid_director, vid_date,  vid_area, vid_pic, vid_score, vid_info, vinfo.cid, vid_serialstate
 from tb_videoinfo vinfo  where vinfo.cid in (select cid from tb_category where pid=#{cid})

 

前面数据库字段的括号去掉

 

版权声明：本文为loveyour_1314原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。