Navicat 导出表结构至 Excel

SELECT COLUMN_NAME AS '字段名称',
  COLUMN_TYPE AS '字段类型',
  IF(IS_NULLABLE='NO','否','是') AS '是否必填',
    COLUMN_DEFAULT As '默认值',
  COLUMN_COMMENT AS '注释'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = '数据库名字'
  AND table_name = '表名字‘;