日常SQL

最新推荐文章于 2024-07-24 22:36:05 发布

Jogger_Ling

最新推荐文章于 2024-07-24 22:36:05 发布

阅读量124

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/Jogger_Ling/article/details/115916436

版权

mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏


select 
	case arch 
	when 0 then "haproxy" 
	when 1 then "sentinel" 
	when 2 then "nvme normal" 
	when 3 then "nvme ha" 
	else "others" 
	end as arch_new,
arch ,id, state from t_ha_instance where state = 40;



select a.id,b.id,a.virtual_ip as vip ,b.virtual_ip from t_ha_instance a join t_db_instance b on a.id=b.cluster_id 
where a.arch in (0,1,3) and a.state=40 and 
(substring_index(a.virtual_ip,'.',1) <> substring_index(b.virtual_ip,'.',1) 
	or substring_index(substring_index(a.virtual_ip,'.',2),'.',-1) <> substring_index(substring_index(b.virtual_ip,'.',2),'.',-1) );