mysql查询库中所有的表名，表中所有的字段名，查询库中有含有某个字段的表，某个表中含有哪些字段

查询该库中有所有的表名

SELECT DISTINCT
	TABLE_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_SCHEMA = '库名';

例如：

SELECT DISTINCT
	TABLE_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_SCHEMA = 'information_schema';

结果：

查询该表中有所有的表名

SELECT
	COLUMN_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_NAME = '表名';

例如：

SELECT
	COLUMN_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	TABLE_NAME = 'CHARACTER_SETS';

结果：

查询该库中含有某个字段的表名

SELECT DISTINCT
	TABLE_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	COLUMN_NAME = '字段名' 
	AND TABLE_SCHEMA = '库名';

例如：

SELECT DISTINCT
	TABLE_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	COLUMN_NAME = 'ID' 
	AND TABLE_SCHEMA = 'information_schema';

结果：

查询该库中某个表都含有哪些字段

SELECT
	COLUMN_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	table_name = '表名' 
	AND table_schema = '数据库名';

例如：

SELECT
	COLUMN_NAME 
FROM
	information_schema.COLUMNS 
WHERE
	table_name = 'INNODB_TABLES' 
	AND table_schema = 'information_schema';

结果：