MySQL查询属性值

记一个小知识

检索一张表的字段属性和注释

SELECT
	COLUMN_NAME,
	COLUMN_COMMENT 
FROM
	information_schema.`COLUMNS` 
WHERE
	TABLE_SCHEMA = 'db_name' 
	AND TABLE_NAME = 'table_name'

检索所有信息

SELECT
	*
FROM
	information_schema.`COLUMNS` 
WHERE
	TABLE_SCHEMA = 'db_name' 
	AND TABLE_NAME = 'table_name'