[EMAIL PROTECTED]
- Original Message -
From: "Jack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 9:58 AM
Subject: Problem on Load Data!
> Dear all
> I had a query here, could someone pls tell me what is in there?
Dear all
I had a query here, could someone pls tell me what is in there?
load data infile 'c:/rate/hkd_rate.csv' into table hkd_deposit
(hkd_chiperiod) fields terminated by ','
This error comes out:
you have an error in your SQL syntax near 'fields terminated by '," at line
1
Aim:
What i wan to
"/" 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
m: "Jack" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>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
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
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' tabl
