Advanced Search

Return to Snippet

Revision: 21333
at December 10, 2009 15:18 by j4kp07
Initial Code 
LOAD DATA INFILE '/tmp/foo.dat'
INTO TABLE bar
FIELDS TEMINATED BY '|'
LINE TERMINATED BY '\n'
(col1, col2, @col3, @col4, col5)
set
col3 = DATE_FORMAT(@col3, '%m/%d/%Y'),
col4 = DATE_FORMAT(@col4, '%Y-%m-%d')
Initial URL 
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Initial Description 
Came across this nice snippet @ mysql.com
Initial Title 
Date formatting with LOAD DATA INFILE
Initial Tags 
mysql, data, csv
Initial Language 
MySQL