Linked Questions
10 questions linked to/from SQLite UPSERT / UPDATE OR INSERT
0
votes
1
answer
76
views
I need an SQL table to update a Unit # instead of creating a new entry if it detects a Unit already exists [duplicate]
I am trying to build a database for managing residents that live in a gated community. The goal is to create a function that makes it easy for a property manager to fill out a form then submit ...
- 11
19
votes
2
answers
3k
views
How can I guarantee unique entries in a Core Data store in a shared app container used by both the host app and an extension?
To ask my question effectively, let's first consider the exact scenario I'm facing:
General Setup
A host iOS 8 app.
One or more iOS 8 extensions (WatchKit, Share, etc.) bundled with the host app.
...
- 12.8k
12
votes
5
answers
3k
views
MYSQL inserting multiple rows unexpectedly
I'm having an issue and was hoping that someone could help me out.
My issue is that whenever I run the code in the "MainFile", It outputs the two ID's that it has added the entries at, but then when ...
- 3,517
7
votes
1
answer
14k
views
How to update or insert with SQLite.swift
I want to update the column of a row if the row already exists, but if it doesn't exist yet then I want to insert a new row.
Related questions
This type of question is popular for SQL in general
...
- 517k
4
votes
2
answers
10k
views
Sqlite: Insert if not exist, Update if exist
I have a database with 2 tables like this:
cg_resp
id | name | email
1 | George | [email protected]
id column is primary_key,autoincremented and name is unique
and
equip_info
id | description ...
- 870
2
votes
1
answer
859
views
on duplicate key update sqlite FMDB
We are creating an app wich uses local and remote DB, the information comes from the remote server and if necessary gets stored in the local DB.
The problem is, some records, will come again to the ...
- 1,003
0
votes
2
answers
353
views
sqlite3 in python 2.7: Comparing DB values with CSV values
I have this code, it reads a csv file for the 2 first columns and appends a list from each row.
with open(self.selected_file[0], 'rb') as csv_file:
itemids = []
...
- 91
0
votes
2
answers
208
views
Profile Millions of Text Files In Parallel Using An Sqlite Counter?
A mountain of text files (of types A, B and C) is sitting on my chest, slowly, coldly refusing me desperately needed air. Over the years each type spec has had enhancements such that yesterday's typeA ...
- 3,728
0
votes
1
answer
75
views
Why am i getting SQLlite constraint error (Code=19) even if i am not leaving any fields null?
I am trying to create a Admin table.Taking the input from the app and adding it to the table.My admin class is used for getting and setting the values .
I tried a lot but unable to identify the issue ...
- 23
0
votes
0
answers
63
views
SQLite: get updated field after upsert
SQLite (and other RDBMS, like PostgreSQL) allow you to perform an insert, and if there's a conflict, execute an update instead. However, getting the final value that was updated seems tricky.
Take ...
- 5,131