Inserting CSV into mysql

Question

this may just be the dumbest question I have asked yet. But I can not figure this out. I am trying to import a CSV into my mysql. But I can not get these areas correct:

Columns separated with: Columns enclosed with: Columns escaped with: Lines terminated with:

Here is an example row in mycsv: AA|Armed Forces Americas|US|United States

what would I place in each one?

That's not a CSV per se.

Karlson
– Karlson

2012-04-12 20:17:06 +00:00
Commented Apr 12, 2012 at 20:17 — Karlson
– Karlson, Commented Apr 12, 2012 at 20:17

Karlson · Accepted Answer · 2012-04-12 20:21:29Z

1

If you have table that match the column configuration of the file what you do is:

LOAD DATA INFILE '<full file path>`
INTO TABLE <tbl_name>
FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n';

If some of the fields may contain | then these fields should be enclosed by " and then the last clause becomes:

FIELDS TERMINATED BY '|' ENCLOSED BY '"' TERMINATED BY '\n'

answered Apr 12, 2012 at 20:21

Karlson

3,0881 gold badge27 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Inserting CSV into mysql

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