: MySQL Lists
Subject: RE: Beginner - Updating a Table from a File
On Wed, 28 Nov 2001, john wrote:
> mysql> load data local infile '/tmp/Parts.txt'
> -> replace
> -> into table Parts
> -> fields
> -> optionally enclosed by '"'
On Wed, 28 Nov 2001, john wrote:
>Yes, but won't this only replace and not load the rest of the items in
> the file?
>
> This is my code, but it only updates the existing items.
>
> load data local infile '/tmp/Parts.txt'
> >replace
> >into table Parts
> >fields opti
On Wed, 28 Nov 2001, john wrote:
> mysql> load data local infile '/tmp/Parts.txt'
> -> replace
> -> into table Parts
> -> fields
> -> optionally enclosed by '"'
> -> terminated by ','
> -> ('PN','APN','C','Q','D')
> Query OK, 100946 rows affected (39.66 sec)
> Records: 100
cing the data is the
command does not know how to align itself with CUST_ID = '1'. Does this
sound correct?
john
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 8:24 AM
To: Thomas Spahni; john
Cc: MySQL Lists
Subject: RE: Beginner - Upd
items?
When using the IGNORE switch, should I use the "|" between REPLACE | IGNORE
as you have done?
thanks for your confirmation.
-Original Message-----
From: Thomas Spahni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:40 AM
To: john
Cc: MySQL Lists
Subject: RE: Beg
On Tue, 27 Nov 2001, john wrote:
>I want to be able to do an update from a text file I have placed in the
> /tmp dir. I have searched the "Manual" and it does not state how to do this.
John,
It took me not too long to find in the very fine Manual:
---quote -
`LOAD DATA INFILE'
lines from /tmp/my_file.txt,
then update (replace, if necessary) the existing lines".
-Original Message-
From: CK Raju [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:44 AM
To: raezor; MySQL Lists
Subject: Re: Beginner - Updating a Table from a File
Elaborate, please.
Elaborate, please.
Raju
On Tuesday 27 November 2001 16:47, raezor wrote:
> Can you update a table from a file? if so where can I find some syntax?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the