Re: Insert only if the entry doesn't exist

2011-02-15 Thread Joerg Bruehe
Hi! Andre Polykanine wrote: Hello Rolando, So if I do INSERT IGNORE INTO `Votes` SET `EntryId`='12345', UserId`='789'; it *won't* insert the second row if there's a row with EntryId set to 12345 and UserId set to 789? If you want to have at most one vote per user on any entry, IMO you

Re: Insert only if the entry doesn't exist

2011-02-14 Thread Jo�o C�ndido de Souza Neto
Instead of insert into you can use replace into. -- João Cândido de Souza Neto Andre Polykanine an...@oire.org escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my last question! Here's one more problem I commonly deal with. There are

RE: Insert only if the entry doesn't exist

2011-02-14 Thread Rolando Edwards
only if the entry doesn't exist Instead of insert into you can use replace into. -- João Cândido de Souza Neto Andre Polykanine an...@oire.org escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my last question! Here's one more problem I

Re: Insert only if the entry doesn't exist

2011-02-14 Thread Andre Polykanine
Subject: Re: Insert only if the entry doesn't exist Instead of insert into you can use replace into. -- João Cândido de Souza Neto Andre Polykanine an...@oire.org escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my last question! Here's one more

RE: Insert only if the entry doesn't exist

2011-02-14 Thread Rolando Edwards
...@oire.org] Sent: Monday, February 14, 2011 3:40 PM To: Rolando Edwards Cc: João Cândido de Souza Neto; mysql@lists.mysql.com Subject: Re: Insert only if the entry doesn't exist Hello Rolando, Sorry, but if I do INSERT IGNORE INTO, then I must indicate a key (typically a unique key

Re: Insert only if the entry doesn't exist

2011-02-14 Thread Andre Polykanine
...@oire.org] Sent: Monday, February 14, 2011 3:40 PM To: Rolando Edwards Cc: João Cândido de Souza Neto; mysql@lists.mysql.com Subject: Re: Insert only if the entry doesn't exist Hello Rolando, Sorry, but if I do INSERT IGNORE INTO, then I must indicate a key (typically a unique key