navicat 如何导出数据库表 的这些信息 字段名 类型 描述

数据库名字 springbootmt74k

表名字 address

SELECT COLUMN_NAME AS '字段名',COLUMN_TYPE AS '类型',COLUMN_COMMENT AS '描述'
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'springbootmt74k' AND TABLE_NAME = 'address';

SELECT COLUMN_NAME AS 字段名,COLUMN_TYPE AS 类型,COLUMN_COMMENT AS 描述
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'springbootmt74k' AND TABLE_NAME = 'address'UNION ALLSELECT '字段总数',CAST(COUNT(*) AS CHAR),'条'
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'springbootmt74k' AND TABLE_NAME = 'address';

SELECT c.COLUMN_NAME AS 字段名称,c.COLUMN_TYPE AS 数据类型,CASE WHEN k.CONSTRAINT_NAME = 'PRIMARY' THEN '是'ELSE '否'END AS 主键,CASE WHEN  c.IS_NULLABLE = 'YES' THEN '是'ELSE '否'END AS 能否空,c.COLUMN_COMMENT AS 字段描述
FROM information_schema.COLUMNS c
LEFT JOIN (SELECT COLUMN_NAME, CONSTRAINT_NAMEFROM information_schema.KEY_COLUMN_USAGEWHERE TABLE_SCHEMA = 'video-question-bank-mini-program' AND TABLE_NAME = 'v_exam_record_detail'AND CONSTRAINT_NAME = 'PRIMARY'
) k ON c.COLUMN_NAME = k.COLUMN_NAME
WHERE c.TABLE_SCHEMA = 'video-question-bank-mini-program'AND c.TABLE_NAME = 'v_exam_record_detail';SELECT '字段总数',CAST(COUNT(*) AS CHAR),'条'
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'video-question-bank-mini-program' AND TABLE_NAME = 'zuixinxianlu';