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
Drop the quotes (') arround the NULL
e.g.: 7,'Markovic Stevo',NULL,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
wow, that was fast, tnx (new on this m. list)
why was mysql.com down for 2 days (or more)?
lp, tomaz
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