Re: default value does not set using LOAD DATA INFILE ...

2003-06-24 Thread Ruth Zhai
riginal Message - From: "Roman Neuhauser" <[EMAIL PROTECTED]> To: "Ruth Zhai" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 7:50 PM Subject: Re: default value does not set using LOAD DATA INFILE ... > please don't pigg

Re: LOAD DATA command error

2003-06-23 Thread Ruth Zhai
By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which version). You may need to compile MySQL with “-enable-local-infile". You may find details on www.mysql.com . Ruth - Original Message - From: "mysql" <[EMAIL PROTECTED]> To: "mySQL List" <[EMAIL PROTECTED]> Sent: Tue

default value does not set using LOAD DATA INFILE ...

2003-06-23 Thread Ruth Zhai
Hi Everyone, I am using LOAD DATA INFILE to import some data to MySQL. I would like to leave some fields blank and use the default value set in the tables. I have spent many hours trying to find the problem, but no luck so far. According to the manual, it should work. I am hoping some one on th