SELECT
count(*) TABLES,
table_schema
FROM
information_schema.TABLES
WHERE
table_schema = 'face'
GROUP BY
table_schema;
-- 查询某个数据库中所有的表名
SELECT
table_name
FROM
information_schema.TABLES
WHERE
table_schema = 'face';
SELECT
count(*) TABLES,
table_schema
FROM
information_schema.TABLES
WHERE
table_schema = 'face'
GROUP BY
table_schema;
-- 查询某个数据库中所有的表名
SELECT
table_name
FROM
information_schema.TABLES
WHERE
table_schema = 'face';