mysql 查询表名
查询所有表信息
select * from INFORMATION_SCHEMA.TABLES
查询指定数据库下的表信息
select * from INFORMATION_SCHEMA.TABLES where table_schema = "dbname"
查询指定数据库下的表名
select table_name from INFORMATION_SCHEMA.TABLES where table_schema = "dbname"
查询所有表信息
select * from INFORMATION_SCHEMA.TABLES
查询指定数据库下的表信息
select * from INFORMATION_SCHEMA.TABLES where table_schema = "dbname"
查询指定数据库下的表名
select table_name from INFORMATION_SCHEMA.TABLES where table_schema = "dbname"