mysql 查询库中所有表和表中所有字段

 

1. 查询中所有的表和表注释

SELECT
	TABLE_NAME,
	TABLE_COMMENT 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	table_schema = '库名'

2. 查询表中所有字段和注释

SELECT
	column_name,
	column_comment 
FROM
	information_schema.COLUMNS 
WHERE
	table_name = '表名' 
	AND table_schema = '库名';