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:
You can even do funky stuff like lookups:
[ Parent
| on HN ]
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 :)