Support UPSERT
roshan opened this issue ยท 3 comments
roshan commented
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
in PostgreSQLINSERT ... ON DUPLICATE KEY UPDATE
in MariaDBINSERT ... ON CONFLICT DO UPDATE
in Sqlite
pratikmallya commented
Need this yesterday