Hello list!
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would like to some how automate it and
At 05:23 AM 5/31/05, James M. Gonzalez wrote:
Im loading rows from a txt tab separated fields file into a MySQL table.
It mostly works, but the date format in one field is not the type that
MySQL likes. So right now Im loading it as a char field. Yes, it is ugly
and a pain to work with. I would
If the data is on a spreadsheet, then why not use excel to rewrite
the date?
For example, copy the text where the dates are,...then format the
entire column to be text and not a date (because excel stores dates
as numbers,...but displays them as dates),...then paste the dates
back into
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 columns
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 ()
{
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
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