News for hackers. Stuff that matters.
Re:A Case for Upserts by dakridge on Sunday February 16, 2014 @09:58AM (#7247761)
I'm sorry, I only just started learning SQL a few days ago... But I was building a simple web application and I wanted to add a user if the email didn't exist else update that user's fields. And I came across this article: http://www.the-art-of-web.com/sql/upsert/

Is that not an upsert?

Re:A Case for Upserts by zwily on Sunday February 16, 2014 @10:06AM (#7247780)
If you read the whole page, you see that it still requires a full table lock to avoid duplicates. A true upsert would not require a table lock.