MySQL查看指定表的字段、数据类型、默认值和注释等信息

SELECT
	t.COLUMN_NAME AS 字段名称,
	t.COLUMN_TYPE AS 数据类型,
	CASE IFNULL(t.COLUMN_DEFAULT,'Null') 
		WHEN '' THEN '空字符串' 
		WHEN 'Null' THEN 'NULL' 
		ELSE t.COLUMN_DEFAULT END  AS 默认值,
	CASE t.IS_NULLABLE WHEN 'YES' THEN '是' ELSE '否' END AS 是否允许为空,
	t.EXTRA AS PK,
	t.COLUMN_COMMENT AS 字段说明
FROM information_schema.COLUMNS t 
WHERE t.TABLE_SCHEMA='global' AND t.TABLE_NAME='news';

1. SELECT
2. t.COLUMN_NAME AS 字段名称,
3. t.COLUMN_TYPE AS 数据类型,
4. CASE IFNULL(t.COLUMN_DEFAULT,'Null')
5. WHEN '' THEN '空字符串'
6. WHEN 'Null' THEN 'NULL'
7. ELSE t.COLUMN_DEFAULT END AS 默认值,
8. CASE t.IS_NULLABLE WHEN 'YES' THEN '是' ELSE '否' END AS 是否允许为空,
9. t.EXTRA AS PK,
10. t.COLUMN_COMMENT AS 字段说明
11. FROM information_schema.COLUMNS t
12. WHERE t.TABLE_SCHEMA='global' AND t.TABLE_NAME='news';

SELECT
	t.COLUMN_NAME AS 字段名称,
	t.COLUMN_TYPE AS 数据类型,
	CASE IFNULL(t.COLUMN_DEFAULT,'Null') 
		WHEN '' THEN '空字符串' 
		WHEN 'Null' THEN 'NULL' 
		ELSE t.COLUMN_DEFAULT END  AS 默认值,
	CASE t.IS_NULLABLE WHEN 'YES' THEN '是' ELSE '否' END AS 是否允许为空,
	t.EXTRA AS PK,
	t.COLUMN_COMMENT AS 字段说明
FROM information_schema.COLUMNS t 
WHERE t.TABLE_SCHEMA='global' AND t.TABLE_NAME='news';

作者： 高志远

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