query: SQLite insert if not exists else update
positive_passages.docid: 33973
positive_passages.text: SQLite - UPSERT *not* INSERT or REPLACE
negative_passages.docid: 28408
negative_passages.text: What's the best way to get the last inserted id using sqlite from Java?
negative_passages.docid: 86181
negative_passages.text: Update table values from another table with the same user name
negative_passages.docid: 121066
negative_passages.text: How to check if list item already exist when adding it with
negative_passages.docid: 16054
negative_passages.text: Return not exists record in the table
negative_passages.docid: 110393
negative_passages.text: How to avoid duplicates while updating a MySQL database?
negative_passages.docid: 112077
negative_passages.text: How to check if a value already exists to avoid duplicates?
negative_passages.docid: 146667
negative_passages.text: Create Trigger that updates the same table before (or after ??) the Insert
negative_passages.docid: 56652
negative_passages.text: Cannot add a NOT NULL column with default value NULL in Sqlite3
negative_passages.docid: 18629
negative_passages.text: Check if a given key already exists in a dictionary and increment it
negative_passages.docid: 25966
negative_passages.text: compare and update a string
negative_passages.docid: 36268
negative_passages.text: Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?
negative_passages.docid: 107962
negative_passages.text: Insert/ Update random date in MySQL
negative_passages.docid: 65406
negative_passages.text: System.ListException: Before Insert or Upsert list must not have two identically equal elements - Deep Dive
negative_passages.docid: 96662
negative_passages.text: Check that criteria are met in a before insert trigger
negative_passages.docid: 99497
negative_passages.text: IF EXISTS taking longer than embedded select statement
negative_passages.docid: 117531
negative_passages.text: Best practice between using LEFT JOIN or NOT EXISTS