List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2002 10:16pm
Subject:RE: problem on Load Data!
View as plain text  
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


Thread
Re: problem on Load Data!ali hafiz9 May
RE: problem on Load Data!Bob Ryan9 May
RE: problem on Load Data!Matthew Walker9 May
RE: problem on Load Data!Bob Ryan9 May