select * from IpResourceInfo a
where find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ss
FROM ipmanage_smh.RoleResources
where roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21
group by roleid))
相关文章
- 01-06[MySQL]快速解决"is marked as crashed and should be repaired"故障
- 01-06MySQL 问题分析：ERROR 1071 (42000) : Specified key was too long; max key length is 767 bytes
- 01-06spring boot 中属性注入，application.properties 自定义前缀以及使用properties 封装mysql
- 01-06.net core系列之《.net core中使用MySql以及Dapper》
- 01-06.NET Core开发日志——Dapper与MySQL
- 01-06mysql数据目录移动
- 01-06/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh: line 19: mysql: command not found
- 01-06Dapper操作Sql Server和MySql数据库
- 01-06mysql数据库连接 application.properties
- 01-06Dapper+Mysql 使用LIKE模糊查询写法采坑