At 2:00 AM +0200 6/25/01, c.smart wrote:
>Drop the quotes (') arround the NULL
>e.g.: 7,'Markovic Stevo',NULL,NULL
No.
To load a NULL value into a column using LOAD DATA, you must use \N.
NULL, with or without quotes, will insert as the word "NULL".
>Clive Smart
>WEBServ
>
>TomazSa wrote:
>
>> I get *.csv file like this (1 string) :
>>
>> 7,'Markovic Stevo','NULL','NULL'
>>
>> When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table)
>>
>> q: I want field to be empty (in table), where the NULL is (in *.csv), how?
>>
> > tomaz, Slovenia
--
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