At 14:59 -0500 5/9/02, Bob Ryan wrote: >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 /.
That's correct. Or you can use doubled backslashes, but "/" is preferred. > >-----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] --------------------------------------------------------------------- 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