List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 1 2001 4:37am
View as plain text  
At 8:40 PM -0700 5/31/01, Roland Hannes Niedner wrote:
>Hi everybody,
>I am new to the list so if my question was answered recently I do apologize
>but I could not find the answer neither in the archive or the manual.
>Problem: I try to load data into a table using LOAD DATA LOCAL INFILE.....
>Into a table containing a TIMESTAMP(14) field. The loading works well except
>that I don't get the current timestamp in this field no matter if I have
>NULL, "NULL", or 'NULL' (the same applies to NOW()) I always ending up with
>00000000000000 in the field.
>I am using the current release of MySQL on a Linux box (RH 6.2).
>Please help.
>BTW if I try an INSERT with the same data (1 row of the file) everything is
>Thanks Hannes

For LOAD DATA, NULL values are represented as \N.

Paul DuBois, paul@stripped
TIMESTAMPRoland Hannes Niedner1 Jun
  • Re: TIMESTAMPPaul DuBois1 Jun