Re: Replace vs On Duplicate
Reply #1 –
Older versions didn't have it. On MyISAM I think it is slower.
It makes sense to update when possible though.
Re: Replace vs On Duplicate
Reply #6 –
Yeah, you are right, it would be probably more logical to have an update that actually does the update and not an insert. LOL
Re: Replace vs On Duplicate
Reply #8 –
I've seen this referred to as "upsert" as well. We could that even though postgre will be a replace until 9.5, or we could try one of the upsert functions out there for postgre.
Re: Replace vs On Duplicate
Reply #9 –
I'm sure I'll confuse it with upset! LOL