新建查询，输入SQL语句
SELECT
COLUMN_NAME,
COLUMN_TYPE,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH,
IS_NULLABLE,
COLUMN_DEFAULT,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_schema = '数据库名'
AND table_name = '数据表名';
将结果导出，给文件命名并保存即可。
参考：
https://www.2cto.com/database/201704/628681.html
http:///qq_27470131/article/details/78738311