News for hackers. Stuff that matters.
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.