A common pattern is "Create if this doesn't exist, otherwise update". The conflict is determined as being on a duplicate key. Upsert is called: * [`INSERT ... ON CONFLICT UPDATE`](https://wiki.postgresql.org/wiki/UPSERT) in PostgreSQL * [`INSERT ... ON DUPLICATE KEY UPDATE`](https://mariadb.com/kb/en/library/insert-on-duplicate-key-update/) in MariaDB * [`INSERT ... ON CONFLICT DO UPDATE`](https://www.sqlite.org/lang_UPSERT.html) in Sqlite
A common pattern is "Create if this doesn't exist, otherwise update". The conflict is determined as being on a duplicate key. Upsert is called:
INSERT ... ON CONFLICT UPDATEin PostgreSQLINSERT ... ON DUPLICATE KEY UPDATEin MariaDBINSERT ... ON CONFLICT DO UPDATEin Sqlite