All Questions
Tagged with insert-update sql-update
91
questions
0
votes
0
answers
81
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
1
answer
40
views
How can I UPDATE a column in a record when that information is the result of a GROUP CONCAT in the same table?
I cannot determine if this should be something nested or a JOIN.
Each record has three values from the column value across from their name in the column variable.
I have a successful GROUP CONCAT that ...
0
votes
1
answer
1k
views
How to upsert record from one db connection to another in postgres using dbeaver?
I have two connections in my dbeaver namely preproduction and postproduction. Both the database have a table called profiles.
I want to upsert data from my postproduction.profiles into preproduction....
0
votes
1
answer
143
views
SQL to update rows to remove words with less than N characters
I have a TAGS column in my Products table in SQL Server. In my web project I split them with space, for example:
"web web_design website website_design"
=> 1.web 2. web_design 3. ...
0
votes
0
answers
287
views
SQL Update and Insert New records if not existing
Hi I am using Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64) Nov 6 2020 16:50:01 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard ...
0
votes
1
answer
556
views
Hibernate batch update issue
For a simple batch update of a MariaDB table, properly mapped as a Hibernate entity class, a simple update via Hibernate produces the error
org.hibernate.StaleStateException: Batch update returned ...
2
votes
2
answers
661
views
Concatenate string instead of just replacing it
I have a table with standard columns where I want to perform regular INSERTs.
But one of the columns is of type varchar with special semantics. It's a string that's supposed to behave as a set of ...
0
votes
3
answers
130
views
Update old data in oracle
hi I have old data and I want to recover them .Lets say I have the following tables .
Table1:
Company
FirstName
All
Beornræd
Table2:
CompanyNames
X
Y
Z
I want to map All to all values of the ...
2
votes
1
answer
138
views
Python Pandas dataframes merge update
My problem is kind of a bit tricky (similar to sql merge/update), and not understanding how to fix: ( I am giving a small sample of the dataframes below)
I have two dataframes :
dfOld
A B ...
-2
votes
1
answer
363
views
SQL UPDATE on with data from same table
I have a next situation with a table, Need to update rows from rows in same table, as you see here:
TABLE
ID
SN
FID
1
12345
1
2
1122
2
3
12345-RG
NULL
4
1122-RG
NULL
I need to UPDATE row 3 from ...
1
vote
3
answers
2k
views
Update Query in SQL using Joins
I am using SQL UPDATE statement with a JOIN clause.
Whenever I update the table, same data is being updated for all the rows.
Below is the SQL query which is used to update the table
update table3 set ...
0
votes
1
answer
1k
views
update value only when value changed
I have to update main_table data from another table. Below is statement
We will have value in any one column among value_string,value_date in a row or for a key, based on type_key. (like if type_key ...
0
votes
0
answers
39
views
Update multiple rows and insert new from another table
i am new to this and i'll try to explain it as simple as i can.
i have two tables. profiles and loyalty profiles.
let's say that the table profiles has 10 rows and each profile created by a user is ...
0
votes
1
answer
160
views
SQL SERVER update or insert after left join
I have a Table Animals
Id | Name | Count | -- (other columns not relevant)
1 | horse | 11
2 | giraffe | 20
I want to try to insert or update values from a CSV string
Is it possible ...
0
votes
2
answers
50
views
Dynamic Insert/update based on where clause in postgresql
I have two tables as shown below
ob_period
person_id ob_start_date
1 2007/02/11
2 2008/05/13
3 2008/07/29
4 2006/03/21
visit
person_id ...