Oct 6 2009
A quick tip – you can import a CSV into a MySQL table pretty easily. The file must exist on the server and you must create the table first, but this command will import your CSV into a MySQL table easily:
LOAD DATA LOCAL INFILE '/tmp/data.csv' INTO TABLE `data_table` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Powered by WordPress. Theme by James Titcumb.
This website, all contents herein unless otherwise stated and the theme by James Titcumb
is licensed under a Creative Commons License.
Based on a work at www.asgrim.com.
RSS Feed icon by Jay Hilgert under a seperate license - see link for details.
