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
)
-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 insert multiple lines to a table with 3 col.
All 3 of them
are a part
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
data if you are not inserting all columns)
If you're not inserting all columns, so will REPLACE!
-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
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
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 mysql
barfs out that this key already exist in the
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