* Antonio De Luna
> I've a second look to de csv file and the format of the date is
> 09/14/1988, so I think it's easier to load it to the mysql date
> format, could it be done using mysqlimport, or LOAD DATA INFILE ??
You can read it into a varchar column and fix it later using something like
th
I've a second look to de csv file and the format of the date is 09/14/1988,
so I think it's easier to load it to the mysql date format, could it be done
using mysqlimport, or LOAD DATA INFILE ??
Thanks
On Tuesday 13 January 2004 18:24, Antonio De Luna wrote:
> Hi, I've got a csv archive with
Antonio De Luna wrote:
>
> Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a
> date field with the mysql date format (ISO ? ) 2003-02-15 ?
Well, if you're a Unix type, then you could pipe the input through a
small Perl script:
#!/usr/bin/perl -w
while (<>)
{
> Hi, I've got a csv archive with a date field 15/02/03, how can I load
> it to a date field with the mysql date format (ISO ? ) 2003-02-15 ?
>
> thank you
>
I wouldn't mind knowing this too, my work around is doing it in php using
fgetcsv to extract the csv data, finding the right rows and colu
