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, S