Advanced Search

Date formatting with LOAD DATA INFILE

/ Published in: MySQL
Save to your folder(s)
Came across this nice snippet @ mysql.com

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. LOAD DATA INFILE '/tmp/foo.dat'
  2. INTO TABLE bar
  3. FIELDS TEMINATED BY '|'
  4. LINE TERMINATED BY '\n'
  5. (col1, col2, @col3, @col4, col5)
  6. set
  7. col3 = DATE_FORMAT(@col3, '%m/%d/%Y'),
  8. col4 = DATE_FORMAT(@col4, '%Y-%m-%d')

URL: http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.