mysql导入csv出现1356_mysql导入CSV文件时CSV输入中的无效列数

I have a table in the database called locations which contains 2 columns(id which is auto incremented , location) , And I have a csv contains 1 column looks like :

When I try to import that file to locations table , I get this error invalid column count in CSV input on line 1.

Also I tried CSV using LOAD DATA but I get this : MySQL returned an empty result set (i.e. zero rows)

解决方案

If Java is supported in your machine, Use below solution

The simple configuration required to do is

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test1

root

If you are interested, Same can be achieved by Java code.

Source source = new File("D:/test_source.csv", ',', false);

Destination destination = new Table("locations", new JDBCConnection("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/test1", "root", ""));

List mapping = new ArrayList<>();

mapping.add(new Mapping("1", "location", null));

Component component = new MigrateExecutor(source, destination, mapping);

component.execute();