‘prod_a’ 为库名
‘table_b’ 为表名
返回值为0则代表没有
返回1则代表存在
SELECT
count(*) num
FROM
information_schema.TABLES
WHERE
table_schema = 'prod_a'
AND table_name = 'table_b'
AND table_type = 'BASE TABLE'
‘prod_a’ 为库名
‘table_b’ 为表名
返回值为0则代表没有
返回1则代表存在
SELECT
count(*) num
FROM
information_schema.TABLES
WHERE
table_schema = 'prod_a'
AND table_name = 'table_b'
AND table_type = 'BASE TABLE'