PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
When you are upserting a row (PostgreSQL >= 9.5), and you want the possible INSERT to be exactly the same as the possible … Read more
upsert
How to use RETURNING with ON CONFLICT in PostgreSQL?
I have the following UPSERT in PostgreSQL 9.5: INSERT INTO chats (“user”, “contact”, “name”) VALUES ($1, $2, $3), ($2, $1, NULL) ON CONFLICT(“user”, … Read more
Oracle: how to UPSERT (update or insert into a table?)
The UPSERT operation either updates or inserts a row in a table, depending if the table already has a row that matches the … Read more
INSERT IF NOT EXISTS ELSE UPDATE?
I’ve found a few “would be” solutions for the classic “How do I insert a new record or update one if it already … Read more
How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT … ON DUPLICATE UPDATE and … Read more
Postgres: INSERT if does not exist already
I’m using Python to write to a postgres database: sql_string = “INSERT INTO hundred (name,name_slug,status) VALUES (” sql_string += hundred + “, ‘” … Read more
SQLite – UPSERT *not* INSERT or REPLACE
http://en.wikipedia.org/wiki/Upsert Insert Update stored proc on SQL Server Is there some clever way to do this in SQLite that I have not thought … Read more
Solutions for INSERT OR UPDATE on SQL Server
Assume a table structure of MyTable(KEY, datafield1, datafield2…). Often I want to either update an existing record, or insert a new record if … Read more
Insert, on duplicate update in PostgreSQL?
Several months ago I learned from an answer on Stack Overflow how to perform multiple updates at once in MySQL using the following … Read more
Insert into a MySQL table or update if exists
I want to add a row to a database table, but if a row exists with the same unique key I want to … Read more