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

数据库名字 springbootmt74k

查询数据库所有表

SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'springbootjen0b';

表名字 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 ALL

SELECT 
  '字段总数',
  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_NAME
    FROM information_schema.KEY_COLUMN_USAGE
    WHERE 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';