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';