Using LOAD DATA INFILE in Java

Question

I am trying to read data from a text file and input them into a database. I found this example in the SQL docs that fits my case:

LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY ',';

So I am trying to write this in Java. So far I have this:

String insertTableSQL = "LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict'"
                    + "INTO TABLE masterdict" + "FIELDS TERMINATED BY \',\'" 
                    ;

But this gives me the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TERMINATED BY ','' at line 1

Jens · Accepted Answer · 2016-08-01 07:44:42Z

2

You miss some blanks:

String insertTableSQL = "LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict '"
                    + " INTO TABLE masterdict" + " FIELDS TERMINATED BY \',\'" 
                    ;

Because you querystring will result in:

LOAD DATA INFILE 'C:/Users/Work/Desktop/test/masterDict'INTO TABLE masterdictFIELDS TERMINATED BY \',\'

answered Aug 1, 2016 at 7:44

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Steve Emman Over a year ago

Jens thank you for your answer :) it works i have no syntax errors now, but instead it gives me this "The MySQL server is running with the --secure-file-priv option so it cannot execute this statement" do you have any idea what this is?

Jens Over a year ago

@SteveEmman Read here: stackoverflow.com/questions/32737478/…

Steve Emman Over a year ago

Thank you! Should i edit my question to include this link too? I think a lot of beginners might run to both problems as well.

Steve Emman Over a year ago

I would upvote your answer as well but unfortunately i must have at least 15 reputation

Collectives™ on Stack Overflow

Using LOAD DATA INFILE in Java

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related