At 2:00 AM +0200 6/25/01, c.smart wrote:
>Drop the quotes (') arround the NULL
>e.g.: 7,'Markovic Stevo',NULL,NULL
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".
>> 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