At 8:40 PM -0700 5/31/01, Roland Hannes Niedner wrote:
>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).
>BTW if I try an INSERT with the same data (1 row of the file) everything is
For LOAD DATA, NULL values are represented as \N.
Paul DuBois, paul@stripped
|• TIMESTAMP||Roland Hannes Niedner||1 Jun|
| • Re: TIMESTAMP||Paul DuBois||1 Jun|