mysql - 表数据导入向导 'Could not determine delimiter'

Question

我正在尝试使用表数据导入向导工具将一个 csv 文件导入到我的数据库中，导入到只有一个属性(它的 ID VARCHAR(10))的表中，导入失败并向我显示此错误:error我检查了 csv 文件以查找任何奇怪的字符或换行符，但一切都很好。我使用的是 8.0.25 版，日志显示如下:

16:00:09 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next
    self.main.go_next_page()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 76, in go_next_page
    self.pages[index].page_activated(True)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 185, in page_activated
    self.call_create_preview_table()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 343, in call_create_preview_table
    self.create_preview_table(self.call_analyze())
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 352, in call_analyze
    if not self.active_module.analyze_file():
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 511, in analyze_file
    self.dialect = csv.Sniffer().sniff(csvsample)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\csv.py", line 188, in sniff
    raise Error("Could not determine delimiter")
_csv.Error: Could not determine delimiter

这是我的 csv 文件的样子:

id_tren
56X0O
12X0Y
91X0F
13X0P
92X0U

Answer 1

csv 是逗号分隔值。

所以你必须给进口商一些逗号

喜欢

id_tren,
56X0O,
12X0Y,
91X0F,
13X0P,
92X0U,

然后你得到

然后选择你想要的列