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,310
questions
1
vote
2
answers
333
views
Column reference in "On Conflict" is ambiguous
I created the following table:
CREATE TABLE IF NOT EXISTS public.publications (
publication_id bigint NOT NULL DEFAULT nextval('eap_publications_publication_id_seq'::regclass),
title character ...
0
votes
1
answer
23
views
Mongoose express server throws, Cast to string failed for value, error when I try to update a db entry
I have this mongoose express function:
exports.updateSingleAddress = (req, res) => {
let keyPassed = req.body.key;
let addressPassed = req.body.address;
if (!keyPassed) {
keyPassed = '...
0
votes
2
answers
229
views
Replacing the column values based on Regex matching SQL
I have my HANA SQL query
select
replace_regexpr('[ \t]+$' in "id" with '' OCCURRENCE ALL)
from TABLE1
that will display the replaced trailing whitespaces for the column ID without ...
0
votes
1
answer
459
views
How to get rows which are inserted/updated only in Insert/Update step in Pentaho?
I'm using Pentaho to insert/update rows to a table with the Insert/Update step. The problem is I want to know which rows are inserted or updated into my table.
But when I try to create a Log step ...
0
votes
0
answers
153
views
Faster way to process 50 million records in Oracle
I'm trying to do a CDC on 60 million records in Oracle .
I need to check 60million source(TABLE_TEMP) records against the Target (TABLE) and do Insert , Update or soft Delete operations.
I tried to ...
0
votes
1
answer
60
views
Need PLSQL block to update Table A and also insert same values in Table B
I need to write a PLSQL block that copies values from Column A for a certain record in Table A and updated the copied values in same Column A for another record in the same Table A. Also, these values ...
1
vote
2
answers
850
views
Python-Pandas -How to update multiple row values with a condition on unique column
I have a main dataframe for which few row values are missing for a candidate. And i have an excel file for which few of these missing values are present in this excel file. So i am trying to update ...
0
votes
0
answers
86
views
How to only update the data that has changed in QTableView (Python)
So basically this is my PandasModel:
class pandasModel(QAbstractTableModel):
def __init__(self, data, editable=False):
QAbstractTableModel.__init__(self)
self._data = data
...
0
votes
1
answer
38
views
Oracle | Replace a pattern in a blob
I have a blob column in a table with below content:
<?xml version="1.0" encoding="UTF-8" standalone="no"?><UserPrefPropertyList xmlns="http://www.dummy.com/...
0
votes
1
answer
81
views
postgresql jsonb update List of string value based on existing values searched in other table
I have two tables like these in postgres db :
TABLE tag (
id number,
name nvarchar
);
TABLE article (
id number,
tags jsonb // List<String> list of **name**s of tags from tag ...
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
762
views
ModelMapper DTO-->Entity. How to skip unconditionally all fields not mapped
I have two classes (entity and DTO)
public class Deliver {
private Long id;
private String uri;
private Instant moment;
private DeliverStatus status; // enum PENDING,ACCEPTED,...
0
votes
1
answer
61
views
How to improve this INSERT code with ON DUPLICATE KEY UPDATE
I had this code:
for chunk in np.array_split(DataFrame, 20, axis=0):
for i in chunk.index:
cursor.execute("INSERT INTO table (col1, col2, col3, col4) VALUES (%s, %s, %s, %s) ON ...
1
vote
2
answers
58
views
Should primary key columns be added in the UPDATE?
In the example code below, col1 and col2 are primary keys in the database!
My question is: should they be added in the part of the code after the ON DUPLICATE KEY UPDATE, as it is already in the code, ...
-2
votes
1
answer
20
views
I try to update name record but I can't
protected void submit_Click(object sender, EventArgs e)
{
Label2.Text = Session["id"].ToString();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["...