mysql获取数据库名 表名及列名

 

mysql

select SCHEMA_NAME from information_schema.SCHEMATA //获取所有的schema 数据库

SELECT TABLE_NAME from information_schema.`TABLES` where TABLE_SCHEMA = "world";//查询指定schema的所有表名


select * from information_schema.COLUMNS where TABLE_NAME = "city" //查询指定表对应的列信息