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 table), where the NULL is (in *.csv), how?
>
> tomaz, Slovenia
---------------------------------------------------------------------
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