lundi 23 mars 2015

Why does UPSERT does a DELETE and INSERT instead of UPDATE (SQLite)

I was wondering why, when using SQLite at least, UPSERT does DELETE and INSERT rather than UPDATE when the entry is already in the table?


Is UPDATE more time-expensive than DELETE & INSERT? Or is UPSERT really meant as an INSERT(force=True) query?


Aucun commentaire:

Enregistrer un commentaire