Look into INSERT ON DUPLICATE or REPLACE statements. You need to
have a primary key or unique key for these too work.
On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi<victorsubervi@stripped> wrote:
> I would like to test the following:
> update maps set map where site=mysite;
> to see if there is such an entry in maps. If there is, then update. If there
> is not, then I would like to execute an insert statement. How do I do that?
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
Q: What's the biggest scourge on plain text email discussions?