7 messages in com.mysql.lists.mysqlRE: problem on Load Data!| From | Sent On | Attachments |
|---|---|---|
| Jack | 05 May 2002 21:39 | |
| Victoria Reznichenko | 06 May 2002 05:25 | |
| ali hafiz | 09 May 2002 12:22 | |
| Bob Ryan | 09 May 2002 12:58 | |
| Matthew Walker | 09 May 2002 13:24 | |
| Bob Ryan | 09 May 2002 14:10 | |
| Paul DuBois | 10 May 2002 15:16 |
| Subject: | RE: problem on Load Data! |
|---|---|
| From: | Bob Ryan (BRy...@chestnut.org) |
| Date: | 05/09/2002 12:58:43 PM |
| List: | com.mysql.lists.mysql |
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:ahaf...@hotmail.com] Sent: Thursday, May 09, 2002 2:23 PM To: nedc...@nedcor.com.hk; mys...@lists.mysql.com; win...@lists.mysql.com 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" <nedc...@nedcor.com.hk>
To: <mys...@lists.mysql.com>, <win...@lists.mysql.com> 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 nedc...@nedcor.com.hk
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com 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 win3...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.