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
,
Andre
Skype: Francophile
My blog: http://oire.org/menelion (mostly in Russian)
Twitter: http://twitter.com/m_elensule
Facebook: http://facebook.com/menelion
Original message
From: Rolando Edwards
To: Andre Polykanine
Date created: , 11:01:40 PM
Subject: Insert only if the entr
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
http://oire.org/menelion (mostly in Russian)
Twitter: http://twitter.com/m_elensule
Facebook: http://facebook.com/menelion
Original message
From: Rolando Edwards
To: João Cândido de Souza Neto
Date created: , 10:33:05 PM
Subject: 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
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
Hi all,
Thanks for your fast answer to my last question!
Here's one more problem I commonly deal with.
There are cases when I need to insert the row only if such a row
doesn't exist, otherwise I need either to update the row or to do
nothing, just skip the query.
The common case is the rat
