load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit
(hkd_chiperiod) fields terminated by '\,';
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Or
"/" 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 n
002 3:24 PM
To: Bob Ryan; ali hafiz; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: problem on Load Data!
Wrong. Windows uses \ for their paths, so MySQL should use the same
thing.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Bob
PROTECTED];
[EMAIL PROTECTED]
Subject: RE: problem on Load Data!
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:[EMAIL PROTEC
]; [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 = "",
column4 = "",
column5 = "";
I think that should do it.
Have yo
Hi Jack,
For question1, I think you need to use insert with set:
insert into table ABC
set column3 = "",
column4 = "",
column5 = "";
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:
Jack,
Monday, May 06, 2002, 7:40:08 AM, you wrote:
J> Two Question :
J> 1.
J> I know that the 'LOAD DATA' command loads a bulk of data into a table, but
J> what happen if i only want to load the data into specifc fields on a table
J> instead of whole table.
J> eg.
J> Let say i had a file with 3
