select * from IpResourceInfo awhere find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ssFROM ipmanage_smh.RoleResourceswhere roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21group by roleid))
本文共 223 字，大约阅读时间需要 1 分钟。
select * from IpResourceInfo awhere find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ssFROM ipmanage_smh.RoleResourceswhere roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21group by roleid))
转载地址：http://dzcaa.baihongyu.com/