1:查询语句
SELECT COLUMN_NAME AS "字段名称",
COLUMN_TYPE AS "数据类型",
COLUMN_COMMENT AS "字段注释"
FROM information_schema.COLUMNS
WHERE TABLE_NAME="ylt_item_price(表名)"
2:选择格式
3:设置导出保存地址![](https://i-blog.csdnimg.cn/blog_migrate/35aecb449a4cfc616660a3125f0f9495.png)
4:自定义导出标题![](https://i-blog.csdnimg.cn/blog_migrate/13c105740a15546627bbfd5b770a73a7.png)
5:开始导出
SELECT COLUMN_NAME AS "字段名称",
COLUMN_TYPE AS "数据类型",
COLUMN_COMMENT AS "字段注释"
FROM information_schema.COLUMNS
WHERE TABLE_NAME="ylt_item_price(表名)"