All Questions
Tagged with insert-update sqlite
47
questions
-1
votes
1
answer
190
views
Syntax error near on while using SQLITE on conflict clause
Here is my syntax where I am trying to update data if already exist but here I am not getting Why this error is coming up I am using SQLITE3.
Can anyone help me with my issue or can suggest me better ...
- 390
2
votes
1
answer
1k
views
Error while doing UPSERT in Sqlite 3.34 - Error: near "DO": syntax error [duplicate]
I am trying to load a daily CSV load file into a main table, so that all new records are inserted and all existing records are updated. I am using UPSERT feature of Sqlite for this purpose.
Here is my ...
-1
votes
2
answers
336
views
Sqlite INSERT or else return existing item
I have the following data structure: ID (int), Name (text), Info (text), List (text).
"List" is a list of enums as string with the intended syntax: "word1,word2,word3"
I'd like to ...
- 816
0
votes
1
answer
97
views
Problem inserting database row using last row in sqlite
I'd like to be able to do the following initially and also at anytime.
insert into balance (closing_amount, opening_amount, created, tx_id)
select closing_amount + :value, closing_amount, :date, :...
- 1,505
0
votes
1
answer
82
views
How to increment data to existing data in ROOM UPDATE query
@Query("UPDATE tmcourses SET totalNumberOfItems = :totalNumberOfItems,totalItemSize = :totalItemSize WHERE courseId = :courseId")
fun update(
totalNumberOfItems: Int,
totalItemSize: Long,
...
0
votes
1
answer
27
views
SQLite: Add up integer tables based on shared indicators
I am aggregating numbers from different sqlite databases into a single output database table.
I need to add up integer columns i1,i2,i3 in the output table based on three indicating columns a,b,c ...
- 910
2
votes
1
answer
14k
views
Correct usage of the SQLite ON CONFLICT clause
I have a SQLite database which, amongst other things, has the following table.
CREATE TABLE IF NOT EXISTS biases
(
data INTEGER NOT NULL,
link INTEGER DEFAULT 0,
bias_type INTEGER,
ignores ...
- 8,780
0
votes
1
answer
104
views
How to update second tab if first tab insert data in local database in react native?
I am using two tabs in my project. In first tab there is a code for insert data in sqlite local database. Second tab is for list data. while I am on second tab insert data perform by first tab. So, I ...
2
votes
2
answers
690
views
How to update sqlite row with concatenate existing values in row with a new value
I would like to add a value (concatenate) at the end of existing values in a column of sqlite table.
ie: the column contains : banana, orange, pear, pinapple
I want to add lemon at the end of the ...
- 45
0
votes
0
answers
280
views
sqlite before insert trigger to insert or update if name exists
i am currently working or SQLite database and I am looking for solution to
minimize the redundant data in my table.
I have a primary key that auto-increment, name as a text and date entered in date('...
- 21
2
votes
1
answer
79
views
Getting error Index 0 requested, with a size of 0 in android Sqlite when want to select
I have an android application using SQLite database. I have a CardView and has data like name, cost and description. My CardView has an option menu to input data and update it. When the option menu ...
- 53
1
vote
0
answers
45
views
No error when updating, but the image cannot updated android sqlite
So I have an SQLite database. I try to update and there is no error in my android application. When I update only the name or the cost, it successfully updated but the image not showing in my gridview....
- 53
1
vote
1
answer
2k
views
Sqlite: replacing or updating a row only if it is changed
An Objective-C iOS app integrates a sqlite with a set of rows, each identified by an ID. For example:
| id | user_name | age |
------------------------------
| 1 | johnny | 33 |
| 2 | ...
- 67
1
vote
1
answer
107
views
Retrieve multiple rowids in SQLite insert or update, using JavaScript
I know SQLite have last_insert_rowid() function. I'd like to create a similar function but I want to retrieve an array of indexes, each one coming from an insert or update into my db.
To be clearer, I ...
- 1,439
0
votes
0
answers
42
views
Database SQLite Application
My application doesn't insert values when I exit from the app and run it again and I have this issue with my database. I am certain that the data are stored in the first run only and I can't add data ...
- 11