MySQL LOAD DATA IN FILE Not Inserting all the values

Question

I have a text file in the following format, which contains about a million coupon codes.

93C9LF,PDF934,24YWJ4
93C9LF,PDF934,24YWJ4
93C9LF,PDF934,24YWJ4

Below is my query

LOAD DATA LOCAL INFILE /var/www/coupons.txt
INTO TABLE coupons
FIELDS TERMINATED BY '' ENCLOSED BY '' ESCAPED BY ''
LINES STARTING BY '' TERMINATED BY ','
(coupon);

When I execute this query only some are inserted into the database. I would like to know what I am doing wrong or what could be done to improve this query.

Grizzly · Accepted Answer · 2016-06-15 14:21:07Z

1

Hi Rezaq you can use this:

LOAD DATA LOCAL INFILE '/var/www/coupons.txt' 
INTO TABLE coupons 
FIELDS TERMINATED BY '\t'
ENCLOSED BY ',' 
LINES TERMINATED BY '\n'
(coupon);

edited Jun 15, 2016 at 14:21

Grizzly

5,9559 gold badges63 silver badges117 bronze badges

answered Jun 15, 2016 at 14:11

Poonam Tiwari

1014 bronze badges

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

3 Comments

Hartmut Holzgraefe Over a year ago

+TERMINATED BY '\t'+ ... shouldn't that be +TERMINATED BY ','+ here? I clearly see a comma as field delimiter in the example above, not a tabulator sign (or other whitespace)

Rezaq Over a year ago

This works totally fine. @BviLLe_Kid. I am loading this into a single column not multiple column.

Grizzly Over a year ago

@Rezaq I wasn't the one who answered the question

Collectives™ on Stack Overflow

MySQL LOAD DATA IN FILE Not Inserting all the values

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related