错误:Operand should contain 1 column(s)
select * from role where id in (select * from users_role where userId = '111'); // 报错了
原因:语法错误,where id in
后面只能跟一个字段,select * from
查询结果为整张表的字段。
修改后:
select * from role where id in (select roleId from users_role where userId = '111');