[EMAIL PROTECTED] (Gilles MISSONNIER) wrote in news:[EMAIL PROTECTED]:
> I rewrite my question in a simpler (?) way : > How could I load in the database, data from a text file containaing > date in a NOT MySQL standard date format [precisely char(10)], so that > I get the date into a MySQL standard date format in a column of type > "date" ? 1. Load your dates in a thedate CHAR(10) column. 2. Then UPDATE foo SET thedate = STR_TO_DATE(thedate, '%d/%m/%Y'); 3. Then ALTER TABLE foo MODIFY COLUMN thedate DATE; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]