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 this list would help me. The following is sql query string I used:
LOAD DATA LOCAL INFILE \' file \' REPLACE INTO TABLE table FIELDS TERMINATED BY \'terminator\' ENCLOSED BY \'\"\' Would someone help me to find what I have done wrong? Your help is highly appreciated. Thanks in advance. Ruth -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]