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.
>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!
>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.
>>From: "Jack" <nedcor4@stripped>
>>To: <mysql@stripped>, <win32@stripped>
>>Subject: problem on Load Data!
>>Date: Mon, 6 May 2002 12:40:08 +0800
>>Two Question :
>>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.
>>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!
>>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
>>"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
>>So what should i do if i want mysql will able to find that file from root
>>Thx a lot!