Create if an entry if it doesn't exist, otherwise update?

0

Issue

Kinda strange to put it into words that short, heh.

Anyway, what I want is basically to update an entry in a table if it does exist, otherwise to create a new one filling it with the same data.

I know that’s easy, but I’m relatively new to MySQL in terms of how much I’ve used it 😛

Solution

Use ‘REPLACE INTO’:

 REPLACE INTO table SET id = 42, foo = 'bar';

See more in the MySQL documentation

Answered By – carl

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave A Reply

Your email address will not be published.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More