List:General Discussion« Previous MessageNext Message »
From:Sean Burlington Date:January 20 2003 9:47am
Subject:Re: What is the best known practice for insertion...?
View as plain text  
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)



>>-----Original Message-----
>>From: Zysman, Roiy [mailto:roiy.zysman@stripped] 
>>Sent: Sunday, January 19, 2003 11:16 PM
>>To: mysql@stripped
>>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 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 table.
>>The solution to it would be probably to query for each entry that I'm
>>about to insert if that entry exists , but it looks like it 
>>would be an
>>enormous overhead. I'm asking this question on a 
>>_performance_ context .
>>What is the best way , ignore the error messages mysql barfs out or
>>query each entry for existences before inserting it ?
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread130381@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-sean.mysql=uncertainty.org.uk@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 


Thread
What is the best known practice for insertion...?Roiy Zysman20 Jan
  • RE: What is the best known practice for insertion...?Daevid Vincent20 Jan
    • Re: What is the best known practice for insertion...?Sean Burlington20 Jan
      • Re: What is the best known practice for insertion...?Paul DuBois20 Jan
  • Re: What is the best known practice for insertion...?Tonu Samuel20 Jan
  • Re: What is the best known practice for insertion...?Sasha Pachev20 Jan
RE: What is the best known practice for insertion...?Roiy Zysman20 Jan
Re: What is the best known practice for insertion...?Steve Edberg20 Jan