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:ahafiz71@stripped]
>Sent: Thursday, May 09, 2002 2:23 PM
>To: nedcor4@stripped; mysql@stripped; win32@stripped>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" <nedcor4@stripped>
>>To: <mysql@stripped>, <win32@stripped>
>>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
> >nedcor4@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.