SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'brain_data' -- 指定你的数据库名
AND table_name LIKE '%xxx%';
SELECT COUNT(*) AS table_countFROM information_schema.tablesWHERE table_schema = 'brain_xxxx'; //统计某个数据库有多少张表
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'brain_data' -- 指定你的数据库名
AND table_name LIKE '%xxx%';
SELECT COUNT(*) AS table_countFROM information_schema.tablesWHERE table_schema = 'brain_xxxx'; //统计某个数据库有多少张表