List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 25 2001 12:59am
Subject:Re: LOAD DATA INFILE + NULL
View as plain text  
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, paul@stripped
Thread
LOAD DATA INFILE + NULLTomazSa25 Jun
  • Re: LOAD DATA INFILE + NULLc.smart25 Jun
    • Re: LOAD DATA INFILE + NULLPaul DuBois25 Jun
Re: LOAD DATA INFILE + NULLTomaz Sajn25 Jun