I think you have to use a forward slash in your path instead of a backslash. C:/ as opposed to C:\
even in windows operating environments I believe you need to use /. -----Original Message----- From: ali hafiz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 2:23 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem on Load Data! Hi Jack, For question1, I think you need to use insert with set: insert into table ABC set column3 = "aaaa", column4 = "bbbb", column5 = "cccc"; I think that should do it. Have you managed to find an answer to question2? Please let me know. Ali >From: "Jack" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: problem on Load Data! >Date: Mon, 6 May 2002 12:40:08 +0800 > >Dear all > >Two Question : >1. >I know that the 'LOAD DATA' command loads a bulk of data into a table, but >what happen if i only want to load the data into specifc fields on a table >instead of whole table. > >eg. >Let say i had a file with 3 column of data, and i want to load these data >into a 'ABC' table's field 3 to 5 and leave field 1 & 2 as it was! > >2. >I copied a file into server's root directory, and i was trying to load that >file's data to table which i had failed using the following command in >MYSQL: >"LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields >terminated by ',' " >It said couldn't find the file! >but if i put the file into the data directory of mysql, then it can find >it! >So what should i do if i want mysql will able to find that file from root >directory? > > >-- >Thx a lot! >Jack >[EMAIL PROTECTED] > > >--------------------------------------------------------------------- >Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before >posting. To request this thread, e-mail [EMAIL PROTECTED] > >To unsubscribe, send a message to the address shown in the >List-Unsubscribe header of this message. If you cannot see it, >e-mail [EMAIL PROTECTED] instead. > _________________________________________________________________ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. --------------------------------------------------------------------- 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