title: MySQL load dates in mm/dd/yyyy format
body: <p>I've got a MySQL load script that almost works, it is perfect except for the date columns, which are not in a MySql friendly format.</p>
  
  <pre>
  load data infile  '/Users/pfarrell/sandbox/waybase/folklore/Titles_1976.csv'
  into table fix76
  fields terminated by ','
  enclosed by '"'
  ignore 1 lines
  (  patentId,  USPatentNum,  title,  grantDate,  filedDate)
  </pre>
  
  <p>The problem is that my dates are in mm/dd/yyyy format. Looks like the str_to_date
  function is what I want, but I can't figure out how to use it in the load command.<br>
  I'm envisioning something like:</p>
  
  <pre>
    grantDate = STR_TO_DATE(something, '%m/%d/%Y'),
  </pre>
  
  <p>but that doesn't work.</p>