Questions tagged [insert-update]
A mixed flavour of data entry mode and data modification mode. It can be used when insert is required for case of non-existing data and modification if data exists.
insert-update
1,308
questions
2
votes
1
answer
49
views
Microsoft Access SQL [duplicate]
I am looking for a solution to fill fields in an Access DB SQL statement.
Any suggestions?
Example of the dataset attached:
Goal:
I am looking for a solution to fill fields in an Access DB SQl ...
- 23
-1
votes
0
answers
12
views
Updating Postgres Table using a Datastream in spark
I am using scala Api "2.12.15" of spark "3.5.0" and i am trying to use a data stream to update the rows of my Postgres table :
my data stream and my table both has the same columns
...
- 11
0
votes
0
answers
39
views
SQLAlchemy ORM 2.0 - create audits (Insert/ Update/ Delete)
I am trying to create audits (get columns with values before and after Update)
Update statement per ORM 2.0 style :
engine = create_engine("sqlite:///sales.db", echo=True)
Base = ...
1
vote
0
answers
39
views
Unable to Update Data in ScyllaDB
I'm encountering an issue while attempting to update data in ScyllaDB using Go. Below is the code snippet I'm using for updating a session record:
func (q *Queries) EndSession(Sessionid string) error {...
- 11
0
votes
1
answer
23
views
ORA-30926: unable to get a stable set of rows in the source tables when updating a a table in a database using another table in another database
I am trying to update a table in a database using another table in another database. This script was working fine until recently when I started getting the error: ORA-30926: unable to get a stable set ...
- 15
0
votes
2
answers
49
views
Update scenario is not working properly when using CASEs or IF statement ON DUPLICATE KEY UPDATE section in MySQL
I need to do bulk insert and update on MySQL so I used the ON DUPLICATE KEY UPDATE. I need to ignore the updated by and updated date fields as existing old data if there are no changes in those record'...
1
vote
1
answer
25
views
Update many documents by pushing an object to an array field when id field matches the id field in the object
Ok that question doesn't sound very clear. I will try to explain.
I have a collection of F1 drivers that contains an array field to store the points earned from each race.
I use a web form to submit ...
0
votes
1
answer
52
views
Creating a datafactory pipeline for updating an insering records
I have one csv file which has data of 3 months and have a key column but it has empty values and I have a second file which has also three months records but one week after the records from the first ...
- 23
0
votes
0
answers
203
views
Delta Tables...do we need partitions for concurrent write/update?
I am starting to use Databricks in AWS. I have a delta table that contains KPIs, with each KPI having a KPI ID (1000, 1001, 1002, etc...). We want to have concurrent processes that update those KPIs ...
- 53
0
votes
0
answers
29
views
How to save each instance from a patch request in Djanog
In my Django appliations, I have four models, Exercise, Workout, Target, and TargetExerciseSet. Here are the models below along with my current Workout View and patch request function. The patch ...
- 59
0
votes
0
answers
50
views
PHP Update API php://input returning unexpected response
I am creating an API to update. When I call the API in Postman, I get a strange response when I var_dump what I am to get.
Here is my code:
$data = json_decode(file_get_contents("php://input&...
- 428
0
votes
0
answers
19
views
Value of one field in one entity has been changed after hibernate call saveOrUpdate
One object has been sent to hibernate saveOrUpdate method for updating the data. Before save the value of one field was different and after save the value in the object got changed. Is this one of the ...
1
vote
1
answer
320
views
Update Access Database Table using Excel VBA
I have a Time In and Time Out buttons in a form.
And I have a VBA Module code that saves the last entered data/last row of an entry from an Excel Table to Access Table and it works perfectly fine. ...
- 610
0
votes
0
answers
75
views
how to write a update statement SQL Oracle developer to get data from tables and input it into their own columns
This is my problem "There can be errors preventing data to be properly inserted into the database. This will require you to go into tables individually to add, delete, or modify data. You see ...
0
votes
2
answers
289
views
How to rightly configure an Azure data factory data flow with a delta file as sink?
I am trying to sink data to a delta file. I want to use a insert and update method using the unique Id column: (sink settings)
Whenever the update method is allowed a AlterRow operation will appear. ...
- 409