All Questions
Tagged with insert-update insert
83
questions
0
votes
2
answers
298
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. ...
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....
-1
votes
1
answer
97
views
How to INSERT INTO SELECT by considering IF EXISTS rules in MySQL? [duplicate]
In MySQL its possible to insert data retrieved from another table, e.g.:
INSERT INTO
`table2`
(
`table2_id`,
`foo`
)
SELECT
`id`,
`foo`
FROM
`table1`
WHERE
....
0
votes
0
answers
279
views
How to Convert SQL Server Query to MySQL Query
I'm trying to convert this SQL Server query to MySQL query
how can i do that?
Fallowing is my SQL server query. I need to convert this query to execute in MySQL.
EpfNO is the Primary key and ...
2
votes
2
answers
660
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
1
answer
62
views
Insert values with all existent possible values
I have a question that I do not know if it's possible. I have a database with some permissions to our system. The system is separated with routines named as numbers (routine 3735, 3734 for example) ...
0
votes
1
answer
34
views
PostgreSQL: Inserting into one table then updating another using the same subquery, within the same single query
I have a fairly intricate query and I am finding it difficult to create the result of updating two different tables from the same subquery in the FROM. The difficulty I am facing is suggesting I have ...
1
vote
1
answer
205
views
Insert a line on each findings from given file using ansible playbook
I want to add the line "*{My-Dept$2}" in file.yaml after *{My-Dept$1} this on every finding, I was able to find a line that starts with *{My-Dept$1} and inserted only one time, and ended ...
0
votes
1
answer
1k
views
how to insert a data to a cell of excel sheet from nodejs
I tried the below code for updating a data in a cell of excel sheet.
The json is getting updated but the cell of that excel sheet is not getting updated with the new value.
Should we do some write ...
1
vote
1
answer
11k
views
Which is the best way to use a Upsert method on Azure Data Factory?
I have some csv files stored in a Blob Storage. Each csv gets updated every day. That update consist in the insertion of some new rows and the modification of some old rows. I'm using Azure Data ...
3
votes
1
answer
2k
views
How to insertMany and update duplicates in mongodb?
I have many orders I would like to insert in MongoDB, the orders are unique indexed by orderID.
I would like to insert all the orders and update order time if one of my order was exists in the ...
1
vote
1
answer
509
views
How to INSERT or UPDATE a large number of rows (regarding the auto_increment value of a table)
I have a MySQL table with around 3 million rows (listings) at the moment. These listings are updated 24/7 (around 30 listings/sec) by a python script (Scrapy) using pymsql - so the performance of the ...
0
votes
1
answer
108
views
Inserting a new row while updating a row in the same table using MySQL triggers
I'm trying to insert a row into a table after updating a row in this same table. I was trying to do this using a trigger. But I found that it's not possible to do that in this method.
What i'm trying ...
0
votes
2
answers
169
views
New and old values in postgresql php
I have a table containing lots of data. In this table I would like to add new and update old values. Therefore, I found the following method
After adapting the query from the response, I still got ...
2
votes
1
answer
1k
views
MySQL Query error - no data supplied for parameters in prepared statement
I'm relatively new to MySQL, and I'm trying to combine my insert and update statements like I saw elsewhere. For the following code,
$query = "this is not the problem";
$ora_stmt = oci_parse($conn, $...