Error loading csv file

Question

I am trying to load csv file into my table. I've run the following code which throws error

LOAD DATA LOCAL INFILE 'info.csv' INTO TABLE tbl_countryip (ipstart, ipend, countrycode) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'  ;

The error is

bash: syntax error near unexpected token `('

I even tried after removing the space between tablename and column names but still the same error Thanks in advance

i dont understand (ipstart, ipend, countrycode)

user557846
– user557846

2015-12-29 05:50:45 +00:00
Commented Dec 29, 2015 at 5:50 — user557846
– user557846, Commented Dec 29, 2015 at 5:50
these are all column names

Sugumar Venkatesan
– Sugumar Venkatesan

2015-12-29 05:52:18 +00:00
Commented Dec 29, 2015 at 5:52 — Sugumar Venkatesan
– Sugumar Venkatesan, Commented Dec 29, 2015 at 5:52

Sanjuktha · Accepted Answer · 2015-12-29 06:01:23Z

1

Try this syntax-

LOAD DATA LOCAL INFILE 'info.csv'
INTO TABLE tbl_countryip
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(col1, col2, col3, col4, col5...);

Hope the below reference link help you

MYSQL-LOAD DATA INFILE

answered Dec 29, 2015 at 6:01

Sanjuktha

1,0813 gold badges13 silver badges29 bronze badges

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

1 Comment

Sugumar Venkatesan Over a year ago

Actually I read that already they mentioned The column list can contain either column names or user variables. That's why I have given the column names

Samir Selia · Accepted Answer · 2015-12-29 05:56:32Z

0

You need to do following changes:

Remove column names. Ensure columns and their sequence in csv file matches exactly with that of table.
Remove \r from LINES TERMINATED BY

Updated Query

LOAD DATA LOCAL INFILE 'info.csv'
INTO TABLE tbl_countryip
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

If first row in your csv file is a column name, use IGNORE 1 LINES after LINES TERMINATED.

answered Dec 29, 2015 at 5:56

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

1 Comment

Sugumar Venkatesan Over a year ago

the problem is the columns doesn't match

Collectives™ on Stack Overflow

Error loading csv file

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related