SQL命令汇总

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.

 

SQL命令汇总

标签：l命令   sel   roc   nod   节点   group by   sele   sql   group