第 1 行的 CSV 输入中的字段计数无效

2022-01-05 00:00:00 csv import mysql phpmyadmin load-data-infile

我正在尝试将 ODS 文件导出到 CSV，但是当我导入到 phpmyadmin 时 - 我收到第 1 行的 CSV 输入中的字段计数无效".

I am trying to export an ODS file to CSV, but when I import into phpmyadmin - I get "Invalid field count in CSV input on line 1."

文件(它有两行以上，但方案是一样的):

File (it has more than two lines but the scheme is the same):

"Administração da Guarda Nacional Republicana"
"Administração de Publicidade e Marketing"

表格:

CREATE TABLE IF NOT EXISTS `profession` (
  `id_profession` int(11) NOT NULL,
  `profession` varchar(45) DEFAULT NULL,
  `formation_area_id_formation_area` int(11) NOT NULL,
  PRIMARY KEY (`id_profession`),
  UNIQUE KEY `profession_UNIQUE` (`profession`),
  KEY `fk_profession_formation_area1` (`formation_area_id_formation_area`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

我从不做类似的事情，可能我需要指定列.csv 只有一列，表格有三列.在这种情况下，文件输入属于职业列

I never do something similar, probably i need to specify the columns. the csv only have one column and the table have three. In this case the file input belongs to profession column

推荐答案

如果您希望将其导入该表，您有 2 个选择:

If you want this to import into that table you have 2 choices:

1) 在文件每一行的数据前后添加逗号，或

1) Add a comma before and after the data in every row of your file, or

2) 删除表中的第一列和第三列，导入数据，然后将删除的两列添加回来.

2) Delete the first and third columns in your table, import the data and then add the 2 columns you deleted back.

相关文章