mysql 查询数据库中所有表名称

分类: IT文章 • 2024-04-10 13:51:45

select table_name 
from information_schema.tables 
where table_schema='数据库名称';

select table_name 
from information_schema.tables 
where table_schema='数据库名称' and table_type = 'BASE TABLE' AND table_schema = DATABASE ();