简单记录下：Navicat 导出表结构至 Excel

    SELECT COLUMN_NAME AS '字段名称',
      COLUMN_TYPE AS '字段类型',
      IF(IS_NULLABLE='NO','否','是') AS '是否必填',
      COLUMN_COMMENT AS '注释'
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_schema = 'bs-gds'
      AND table_name = 'sys_menu';