MySQL CSV Import

Question

I am currently importing a large data set from a CSV file and I keep getting the error duplicate primary key. The issue is I cannot add a new column to the csv for an autoincrement column in the database.

Is there a way while importing to make it skip a field via the query?

I.e I have 2 columns in the CSV and 3 in the database where the 3rd is the primary key

Naktibalda · Accepted Answer · 2014-08-14 11:34:06Z

1

Give a list of fields present in the file.

LOAD DATA INFILE 'file.csv' INTO TABLE tablename(col2,col3);

answered Aug 14, 2014 at 11:34

Naktibalda

14.2k5 gold badges37 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

MySQL CSV Import

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related