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
>fine.
>
>Thanks Hannes
For LOAD DATA, NULL values are represented as \N.
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
