正文

mysql查同个实例两个数据库中的表名差异

IP云V管理员/2022-12-02/2 阅读

12/02

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

select

    TABLE_NAME

from (

    select

         TABLE_NAME

        ,count(1) as cnt

    from information_schema.tables

    where TABLE_SCHEMA in ('db_a','db_b')

        and (table_name not like '%2018%' and table_name not like '%2019%')

    group by TABLE_NAME

) t1

where cnt <> 2

limit 50

;