MySQL单库中Tables,columns对比表元数脚本 脚本: 以下案例中都是 新库test1, 旧库test 。 1.对比表范围差异: select a.n_ts as "新库", a.n_tn as "新库表名", a.o_ts as "旧库", a.o_tn as "旧库表名" , case when a.n_tn is null then '新库缺表' when a.o_tn is null then '旧库缺表' else '表名一致' en 数据运维 2024-05-28 捡田螺的小男孩