MySQL 获取所有库名、表名、字段名

• 存放表名和库名的对应

	select * from information_schema.tables 

• 存放字段名和表名和库名的对应

	select * from information_schema.columns 

查询库名

SELECT
	table_schema 
FROM
	information_schema.tables 
GROUP BY
	table_schema
-- -- -- -- -- -- -- -- -- -- -- -- -- -- 	
SELECT
	table_schema 
FROM
	information_schema.COLUMNS 
GROUP BY
	table_schema

查询指定库的表名

SELECT 
	TABLE_NAME 
FROM
	information_schema.tables 
WHERE
	table_schema = 'information_schema'
-- -- -- -- -- -- -- -- -- -- -- -- -- -- 	
SELECT 
	TABLE_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = 'information_schema' 
GROUP BY
	TABLE_NAME

查询指定库指定表的字段名

SELECT
	column_name 
FROM
	information_schema.COLUMNS 
WHERE
	table_schema = 'information_schema' AND table_name = 'columns'