On Mon, 2003-01-20 at 09:15, Zysman, Roiy wrote:
Hi All,
I'm trying to insert multiple lines to a table with 3 col. All 3 of them
are a part of the primary key.
But while inserting the data , sometime occurs the situation where I
want to insert an already exist entry with the same keys. And
existence, delete, insert
???
Roiy
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 9:54 AM
To: 'Zysman, Roiy'; [EMAIL PROTECTED]
Subject: RE: What is the best known practice for insertion...?
This may be useful to you: http
Daevid Vincent wrote:
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
replace works very nicley and is IMO a good extension to standard SQL
another way that may be suitable is to delete first and then insert
(this may erase data if you are not inserting all columns)
This page (Section 5.2.9: Speed of INSERT Queries) might be of interest:
http://www.mysql.com/doc/en/Insert_speed.html
You might also want to investigate the INSERT IGNORE command (IGNORE
means ignore all inserts with duplicate unique keys), for example:
INSERT IGNORE
INTO your_table
At 9:47 + 1/20/03, Sean Burlington wrote:
Daevid Vincent wrote:
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
replace works very nicley and is IMO a good extension to standard SQL
another way that may be suitable is to delete first and then insert
(this may erase
On Monday 20 January 2003 12:15 am, Zysman, Roiy wrote:
Hi All,
I'm trying to insert multiple lines to a table with 3 col. All 3 of them
are a part of the primary key.
But while inserting the data , sometime occurs the situation where I
want to insert an already exist entry with the same
This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
-Original Message-
From: Zysman, Roiy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 19, 2003 11:16 PM
To: [EMAIL PROTECTED]
Subject: What is the best known practice for insertion...?
Hi All,
I'm trying to