title: Importing a CSV to MySQL with different date format
body: <p>I'm doing my first CSV import into MySQL and noticed that the date in the CSV has the format <code>31-Jan-2011</code>. How can I convert this to <code>2011-01-31</code> so I can place it in the DATE datatype? The first thing which came to mind is let PHP do the conversion then insert it into a 2nd table but I'm guessing that's...not right.</p>