How to specify column names when loading data to mySQL table?

Question

How should I specify the columns names when I want to load a MySQL table from a local .csv file using the LOAD DATA LOCAL FILE command in MySQL?

I'm voting to reopen this, since the other question stackoverflow.com/questions/4202564/… has no accepted answer and an incorrect answer before the correct one. Close again if you disagree. — ysth
– ysth, Commented Dec 6, 2019 at 21:17
@ysth having an accepted answer is not a criterion for a dupe target and the most upvoted answer is a correct answer, altgough other answers there also work. Your answer is just a repeat of what's already there, confirming that is indeed a duplicate. — Shadow
– Shadow, Commented Dec 6, 2019 at 22:15

ysth · Accepted Answer · 2019-12-06 21:14:11Z

0

You specify a comma seperated list of columns, in parentheses, at the end (but before the optional SET parameters).

See https://dev.mysql.com/doc/refman/8.0/en/load-data.html#load-data-column-list

answered Dec 6, 2019 at 21:14

ysth

99.1k6 gold badges126 silver badges219 bronze badges

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

2 Comments

BlueSkies Over a year ago

My input is a .CSV file with the first line listing column names. Then why do I need to specify it twice?

ysth Over a year ago

That's how it works. You need to specify the columns in the SQL and use the IGNORE parameter to have it skip the first line

Collectives™ on Stack Overflow

How to specify column names when loading data to mySQL table?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related