Re:Show HN: Convert CSV files into MySQL insert scripts
by akx on Thursday August 28, 2014 @07:50AM
(#8236764)
If you're fortunate enough to be able to put `data.csv` on the MySQL server, that is.
[ Parent
| on HN ]
Re:Show HN: Convert CSV files into MySQL insert scripts
by masklinn on Thursday August 28, 2014 @07:56AM
(#8236781)
Add LOCAL (as in, "LOAD DATA LOCAL INFILE") and the path is looked up in the client's filesystem, with the file uploaded through the connection before the command is run.
Re:Show HN: Convert CSV files into MySQL insert scripts
by akx on Thursday August 28, 2014 @09:10AM
(#8237007)
Cool. I swear that didn't exist the last time I looked at the docs for LOAD DATA INFILE...
Re:Show HN: Convert CSV files into MySQL insert scripts
by jeremysmyth on Thursday August 28, 2014 @07:53AM
(#8236774)
...or if you can use the LOAD DATA LOCAL INFILE syntax on that server/client.