Tool for importing CSV files into MySQL database?

Question

I've got several CSV files I want to import into a table. They all contain different numbers of columns, so some data will be absent during each import. I need a tool that will let me map which CSV column goes into which MySQL column. Doesn't look like MySQL workbench can do this. What else can I use?

I would start by adjusting the data with a spread sheet like excel in order to remove the column issues. — madmik3, Jan 27 '11 at 05:35

score 7 · Accepted Answer · answered Jan 27 '11 at 05:35

7

MySQL has the LOAD DATA INFILE syntax:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
 LINES TERMINATED BY '\r\n'
 IGNORE 1 LINES;

See the documentation about custom data handling.

answered Jan 27 '11 at 05:35

OMG Ponies

325,700
82
523
502

What if I want to omit a field in the CSV? – mpen Jan 27 '11 at 05:44
2

Read the manual page he already linked which has the syntax for mapping CSV fields to columns. It has examples. – Dan Grossman Jan 27 '11 at 05:48
@Dan: Sorry... it was half way down the page...have to use a dumbie value. – mpen Jan 27 '11 at 05:52

score 4 · Answer 2 · edited Oct 27 '12 at 14:28

4

If you're running on a Mac, Sequel Pro is pretty good for this sort of thing (as long as you import each CSV file individually).

http://www.sequelpro.com/

edited Oct 27 '12 at 14:28

SchmitzIT

9,227
9
65
92

answered Mar 04 '12 at 07:35

jranz

41
1

Tool for importing CSV files into MySQL database?

2 Answers2

Linked

Related