Re: Performance of ON DUPLICATE KEY and other options?

[Mark Modrall]

Jay Pipes wrote:
> What is the benefit of updating the QID at all if
> the query text matches?
>

I don't want to update QID when the text matches, but on the man page for ON DUPLICATE KEY UPDATE, it says that

ON DUPLICATE KEY UPDATE qid=LAST_INSERT_ID(qid)

is how you prime LAST_INSERT_ID() to return the value for pre-existing entries so that

SELECT LAST_INSERT_ID()

will give you back the last id, pre-existing or not.

I just tried

ON DUPLICATE KEY UPDATE LAST_INSERT_ID(qid)

and it doesn't parse.

Thanks
-mark