insert-update – IT Nursery

How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?

May 12, 2022 by IT Nursery

A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT … ON DUPLICATE UPDATE and the standard supports as part of the MERGE operation. Given that PostgreSQL doesn’t support it directly (before pg 9.5), how do you do this? Consider the following: CREATE TABLE testtable ( id … Read more

Insert into a MySQL table or update if exists

April 15, 2022 by IT Nursery

I want to add a row to a database table, but if a row exists with the same unique key I want to update the row. For example: INSERT INTO table_name (ID, NAME, AGE) VALUES(1, “A”, 19); Let’s say the unique key is ID, and in my Database, there is a row with ID = … Read more