Import to MySQL from a CSV file

[asai]

Hi,

I am trying to write a program that can import the content of a CSV file into a table in MySQL.
Any good links to tutorials?

I am using Netbeans...

[noobplus]

Hi,

I am trying to write a program that can import the content of a CSV file into a table in MySQL.
Any good links to tutorials?

I am using Netbeans...

hi,
google first result
Import Data from Txt or CSV files into MYSQL database tables

regards
dhilip

[asai]

Thanks!

[noobplus]

Thanks!

welcome , click like button

[asai]

I have tried this but something isn't right with my code...

String filename = textFileName.getText();
String query = "LOAD DATA INFILE '"+filename+"' INTO TABLE TestTable  FIELDS TERMINATED BY ',' (FirstName,LastName,Location)";

I have a textfield for input of the filepath.
I type C:\Temp\Test.csv in this field, but when I run the code I get an exeption:

java.sql.SQLException: File '/var/lib/mysql/genealogy/C:Temp	est1.csv' not found (Errcode: 2)

EDIT: I changed the query to this:

String query = "LOAD DATA LOCAL INFILE '"+filename+"' INTO TABLE TestTable  FIELDS TERMINATED BY ',' (FirstName,LastName,Location)";

But it still do something wrong with the path...

[asai]

Update: I have managed to get it to work, but not 100%...
If I write the path like this: C:\\Temp\\test.csv it imports the content of the file.

I would also like to have the first row in the csv file to hold the table columnnames.
Any suggestions?

[Tolls]

Go to the MySQL documentation and read up on how that command works.
There may well be options on it.
This really, really, isn't a Java question.