MySQL查看数据库中所有表名、表注释和其他信息

文章目录 隐藏

1 原理

2 显示并导出数据库中所有表的核心信息

原理

查询 information_schema.TABLES 表。

SELECT
	*
FROM
	information_schema.TABLES
WHERE
	table_schema = 'global'  # 数据库名称

1. SELECT
2. *
3. FROM
4. information_schema.TABLES
5. WHERE
6. table_schema = 'global' # 数据库名称

SELECT
	*
FROM
	information_schema.TABLES
WHERE
	table_schema = 'global'  # 数据库名称

 

information_schema.TABLES 表中含有整个数据库中关于数据表的所有信息。

显示并导出数据库中所有表的核心信息

还是依靠information_schema.TABLES 表，通过SQL语句查询出来需要显示和导出的列。

例如：

SELECT
TABLE_NAME AS '表名称',
ENGINE AS '存储引擎',
TABLE_ROWS AS '行数',
TABLE_COMMENT AS '表注释'
FROM
information_schema.TABLES
WHERE
table_schema = 'global'
ORDER BY
TABLE_ROWS
DESC

1. SELECT
2. TABLE_NAME AS '表名称',
3. ENGINE AS '存储引擎',
4. TABLE_ROWS AS '行数',
5. TABLE_COMMENT AS '表注释'
6. FROM
7. information_schema.TABLES
8. WHERE
9. table_schema = 'global'
10. ORDER BY
11. TABLE_ROWS
12. DESC

SELECT
TABLE_NAME AS '表名称',
ENGINE AS '存储引擎',
TABLE_ROWS AS '行数',
TABLE_COMMENT AS '表注释'
FROM
information_schema.TABLES
WHERE
table_schema = 'global'
ORDER BY
TABLE_ROWS
DESC

 

作者： 高志远

高志远，24岁，男生 查看高志远的所有文章