SQL命令汇总
1. select rocketmq_id,broker_name,ip,count(*) as num from t_rocketmq_node group by rocketmq_id,broker_name,ip having num>1 order by rocketmq_id; 查找主从在同一IP的集群和节点
2. select rocketmq_id,ip,port,type,count(*) as num from t_rocketmq_node where type=‘namesrv‘ group by rocketmq_id having count(rocketmq_id) > 1 order by rocketmq_id; 查找所有集群对应的namesrv
3.
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/21584.html
