title: MySQL how do I insert now() date when doing a LOAD DATA INFILE?
body: <p><strong>I'm importing data from a file 'infile.txt' and I'm using the table:</strong> <em>People</em> (ID is auto_incremented) <strong>to insert it into</strong></p>
  
  <pre><code>ID DATE NAME
  </code></pre>
  
  <p><strong>infile.txt</strong></p>
  
  <pre><code>Ben
  Jim
  Jack
  </code></pre>
  
  <p><strong>I'm using this method</strong></p>
  
  <pre><code>LOAD DATA INFILE '~/infile.txt'      
  INTO TABLE People
  FIELDS TERMINATED BY ','
  LINES TERMINATED BY '\n'
  (DATE, NAME);
  </code></pre>
  
  <p><strong>Desired output</strong></p>
  
  <pre><code>   ID  DATE                 NAME
      1  2012-03-06 15:13:40  Ben
      2  2012-03-06 15:13:41  Jim
      3  2012-03-06 15:13:42  Jack
  </code></pre>