Re: Insert only if the entry doesn't exist

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, IM

Re: Insert only if the entry doesn't exist

m: Andre Polykanine [mailto:an...@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

RE: Insert only if the entry doesn't exist

nine [mailto:an...@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

Re: Insert only if the entry doesn't exist

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" escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my

RE: Insert only if the entry doesn't exist

bject: 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" escreveu na mensagem news:1621362474.20110214201...@oire.org... Hi all, Thanks for your fast answer to my last

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" 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 cases when