Hi Bob,
I have not actually used mysqlimport, I generally use load data infile from
within
mysql (have you tried this, its usage is in the manual). I have found that if
you have a date
that does not comply with the mysql date format (yyyy/mm/dd) you have no choice
but to change it, plus as far as I am concerned there are too many date
conventions around the worl that confuse people. this format however does not.
hope this helps
cheers
steven
Bob wrote:
> I have a tab delimited file that I am using to load data into a new
> table...I can get everything loaded except for my date information...it is
> currently in yy-mm-dd (i.e., 99-05-12) but when the data gets loaded, the
> date field is empty...I have tried using both the DATE and DATTETIME values
> but neither populates the table....I am uploading approximately 13000 lines
> and I am getting 25000+ warnings but I'm not sure what to do...all of the
> other fields are uploaded and display correctly....
>
> Thanks for the help
>
> btw - I think mysql under NT4 will do just fine once I learn my way around
> it...I'm also using php3 for some manipulation and admin...
>
> Bob
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread95@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
