有没有办法将模型导出到mysql工作台中的csv？(is there a way to export a model to a csv in mysql workbench?)

有没有办法将模型导出到mysql工作台中的csv？(is there a way to export a model to a csv in mysql workbench?)

在Mysql工作台中，我创建了一个包含八个表和大约50列的模型。

有没有办法将模型（而不是数据）导出到csv？ 谢谢。

In Mysql workbench, I have created a model with eight tables, and about 50 columns.

is there a way to export the model (not data) into a csv? Thanks.

最满意答案

您可以运行以下查询：

SELECT * INTO OUTFILE '/path/to/model.csv' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'mydb' AND TABLE_NAME = 'mytable'

您可以在此处找到有关COLUMNS表的更多信息。

You could run the following query:

SELECT * INTO OUTFILE '/path/to/model.csv' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'mydb' AND TABLE_NAME = 'mytable'

You can find some more information about the COLUMNS table here.