Re:Show HN: Convert CSV files into MySQL insert scripts
by phpnode on Thursday August 28, 2014 @07:09AM
(#8236664)
MySQL already supports loading CSVs directly, why convert them first? http://dev.mysql.com/doc/refman/5.1/en/load-data.html
[ Parent
| on HN ]
Re:Show HN: Convert CSV files into MySQL insert scripts
by jeremysmyth on Thursday August 28, 2014 @07:12AM
(#8236672)
It also has the CSV storage engine which actually uses a CSV file as its data back-end, no conversion required.
Re:Show HN: Convert CSV files into MySQL insert scripts
by blowski on Thursday August 28, 2014 @07:20AM
(#8236684)
There are occasions where you can't just do a straight insert. Perhaps you need to conditionally create a foreign record, or you want to format a value on insert instead of doing it directly in the CSV.
That said, I can't see how the OP actually helps me with that.
Re:Show HN: Convert CSV files into MySQL insert scripts
by jeremysmyth on Thursday August 28, 2014 @07:41AM
(#8236735)
LOAD DATA INFILE can't conditionally create a foreign record, but you can certainly format a value on insert by using the SET clause, for example:
LOAD DATA INFILE 'people.txt'
INTO TABLE Person (@first, @last, date_of_birth)
SET full_name = CONCAT(LEFT(@first, 1), '. ', @last);
You can even do funky stuff like lookups: LOAD DATA INFILE 'projects.txt'
INTO TABLE Projects(@first, @last, project)
SET person_id =
(SELECT id FROM people
WHERE name = CONCAT(@first, ' ', @last) LIMIT 1);
Re:Show HN: Convert CSV files into MySQL insert scripts
by michaelmior on Thursday August 28, 2014 @08:17AM
(#8236825)
Cool! I wasn't aware you could do that sort of thing with LOAD DATA INFILE. Thanks :)
Re:Show HN: Convert CSV files into MySQL insert scripts
by blowski on Thursday August 28, 2014 @11:25AM
(#8237652)
I didn't know that either - thanks for sharing.