MySQL - 数据库表结构导出到 Excel

SELECT
  COLUMN_NAME as 字段名称,
  COLUMN_TYPE as 数据类型,
  if(COLUMN_KEY='PRI','Y','N') as 主键,
  COLUMN_COMMENT as 备注
FROM
  INFORMATION_SCHEMA. COLUMNS
WHERE
  table_schema = '数据库名称'
AND 
  table_name = '数据表名称'

SELECT '字段名称','数据类型','主键','备注'
UNION
SELECT
  COLUMN_NAME as 字段名称,
  COLUMN_TYPE as 数据类型,
  if(COLUMN_KEY='PRI','Y','N') as 主键,
  COLUMN_COMMENT as 备注
FROM
  INFORMATION_SCHEMA. COLUMNS
WHERE
  table_schema = 'mydata'
AND 
  table_name = 'account'
INTO OUTFILE 'C:/Users/Administrator/Desktop/account.xls'

SELECT 'SQL字段名称','数据类型','非空','主键','备注'
UNION
SELECT
 COLUMN_NAME as `SQL字段名称`,
-- COLUMN_NAME as `JAVA字段名称`,
 COLUMN_TYPE as `数据类型`,
 if(IS_NULLABLE='NO','Y','N') as `非空`,
 if(COLUMN_KEY='PRI','Y','N') as `主键`,
 COLUMN_COMMENT as `备注`
FROM
 INFORMATION_SCHEMA. COLUMNS
WHERE
 table_schema = 'dsp'
AND
 table_name = 'dsp_supplier'
-- INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/dsp_supplier.xlsx'