存放表名和库名的对应
select * from information_schema.tables
存放字段名和表名和库名的对应
select * from information_schema.columns
查询库名
SELECTtable_schema FROMinformation_schema.tables GROUP BYtable_schema-- -- -- -- -- -- -- -- -- -- -- -- -- -- SELECTtable_schema FROMinformation_schema.COLUMNS GROUP BYtable_schema
查询指定库的表名
SELECT TABLE_NAME FROMinformation_schema.tables WHEREtable_schema = 'information_schema'-- -- -- -- -- -- -- -- -- -- -- -- -- -- SELECT TABLE_NAME FROMinformation_schema.COLUMNS WHEREtable_schema = 'information_schema' GROUP BYTABLE_NAME
查询指定库指定表的字段名
SELECTcolumn_name FROMinformation_schema.COLUMNS WHEREtable_schema = 'information_schema' AND table_name = 'columns'