Re: INSERT ON DUPLICATE KEY UPDATE

On 2004-06-18 18:02:18 UTC, Richard Huxton wrote:
> Out of curiosity, why don't you know whether you're inserting or
> updating? It always worries me when I don't know what my application is
> doing.

This is the example:

I'm downloading a list of products from the web and they already have a
product_id (that's the primary key), in my table I have many fields that
I use myself like comments, stock, ... But when downloading the list I
only have the product_id, the product name, the price and the remote
stock. So I must insert data like the remote stock without removing any
of my data and leaving all the other columns unmodified.