Re: Dumb Question of the day (maybe year)

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
>
> --
> TK
> http://www.wejuggle2.com/
> Still Having a Ball

Hello Terry,

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

"2005-05-23";hello;

Joseph Melnick
JM Web Consultants
http://www.jphp.com/


.

Relevant Pages

  • Re: Dumb Question of the day (maybe year)
    ... > I am using phpMyAdmin to access MySQL for inputting data - built one ... I am uploading text files using; ...
    (alt.php)
  • Dumb Question of the day (maybe year)
    ... I am using phpMyAdmin to access MySQL for inputting data - built one table - no problems. ... I am uploading text files using; as a delimiter. ...
    (alt.php)
  • Re: S-Video: display properties?
    ... Terry ... I'll try installing drivers again. ... But I only built the machine last ...
    (microsoft.public.windows.mediacenter)
  • Re: Dumb Question of the day (maybe year)
    ... >> I am using phpMyAdmin to access MySQL for inputting data - built one ... >> Second table includes a date (configured as date not datetime). ...
    (alt.php)
  • Re: GHOST 8.0?
    ... Kevin wrote: ... >>journal has been built and if not build one. ... > Thanks for the reply Terry, ...
    (Fedora)