Re: Dumb Question of the day (maybe year)

Joseph Melnick wrote: 
Terry wrote:

"Terry" <tknospa@xxxxxxxxxxxxx> wrote in message news:42c144fb$1_1@xxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am using phpMyAdmin to access MySQL for inputting data - built one table - no problems. I am uploading text files using ; as a delimiter. Second table includes a date (configured as date not datetime). I have tried:
2001-21-06;hello; \r\n
20002106;goodby; \r\n
'2001-21-06';hello; \r\n
'20002106';goodby; \r\n

All I get is:
Date           comment
0000-00-00     hello

I have looked at the manual for MySQL and php, googled - this is so simple no one else has a problem, right?

TIA



Hello Terry,

Did you try to optionally quote the date field on import?

"2005-05-23";hello; 
I have now - same result.
"2001-21-06";hello; \r\n
"20002106";goodby; \r\n
Yields:
Date           comment
0000-00-00     hello
0000-00-00     goodby

--
TK
http://www.wejuggle2.com/
Still Having a Ball (even if I am lost ;-)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
.

Relevant Pages

  • Re: Dumb Question of the day (maybe year)
    ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ... Still Having a Ball ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... Terry wrote: ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ...
    (alt.php)
  • Re: Dumb Question of the day (maybe year)
    ... I am uploading text files using; as a delimiter. ... Second table includes a date (configured as date not datetime). ... If vegetarians eat vegetables, beware of humanitarians! ...
    (alt.php)
  • Excel Date Time to Unix Time
    ... I am uploading this feild into mysql I need the datetime to be converted to ...
    (microsoft.public.excel)
  • Excel Date Time to Unix Time
    ... I am uploading this feild into mysql I need the datetime to be converted to ...
    (microsoft.public.excel.programming)