All Questions
Tagged with insert-update sql-insert
34
questions
0
votes
0
answers
30
views
How update the value in SubForm if is duplicate in access
In access I have Form name FB (table name = FB) and SubForm name FBB ( table =FBB) (relationship one to many)
I use
( currentdb.execute "insert into FBB (FBID, ProductName, Quantity) "& ...
-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
....
1
vote
1
answer
2k
views
How to not increment sequence when conflict of insert occurs
When a conflict occurs on insert into a table with an auto incrementing id column, the sequence gets bumped causing a gap in the id range, which for me is undesirable.
Here is a simplified version of ...
0
votes
1
answer
46
views
Inserting 0s for dates currently without data, after a key's first appearance
I've got a table that looks something like the following
Date
Key
Metric
2021-01-31
A
6
2021-02-28
A
3
2021-05-31
A
3
2021-03-31
B
4
2021-04-30
B
1
2021-05-31
B
2
What I'd like to do is insert ...
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) ...
1
vote
1
answer
383
views
Create table and insert rows if doesn't exist, else just insert
I am able to create table, shred JSON and add data if it does not exist in SQL Server:
DECLARE @json nvarchar(max);
SET @json = N'[{"IplayerName": "Pilipiliz",
&...
0
votes
0
answers
72
views
Use SSRS 2012 to insert into oracle database table
Currently I have a stored procedure used to populate and update an SSRS report. The report is able to change the country and region that is assigned to the test code using the below scripts :
IF ...
0
votes
0
answers
29
views
INSERT IGNORE INTO multiple rows but on fail UPDATE [duplicate]
I have this customer table:
id = primary key
driver_id = unique int
user_id = foreign key to another table
Table:
+----+-----------+---------+
| id | driver_id | user_id |
+----+-----------+---------...
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, :...
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 ...
1
vote
2
answers
501
views
SQL Query Updating an already exisiting Entry, if not then make a new entry
Currently I'm working on updating an already exisiting table on my company's db. The connection works fine, my query though gives me some headache.
What I want to do: logging with 2 tables (Job-Table ...
2
votes
0
answers
101
views
import data from source db to target db using flask sqlalchemy
I want to fetch data from one source database and insert it into my targeted database using flask SQL alchemy
Database_connection
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:root@...
-1
votes
1
answer
123
views
How to insert into values without duplicates?
I created new table on another database which names "workers":
CREATE TABLE workers (
ID_WORKER int(11) NOT NULL,
FNAME varchar(20) NOT NULL,
LNAME varchar(20) NOT NULL,
WORKERS_GROUP varchar(20) NOT ...
0
votes
1
answer
31
views
Saving data into a table
I try to save the data into a table but it doesn't work. But another program with similar code does, why?
<?php
$nik = $_POST['nik'];
$no_kk = $_POST['no_kk'];
$nama = $_POST['nama']...
0
votes
1
answer
67
views
Update in one single Oracle Query
I tried to write the one single code in Oracle database but I couldn’t merge it to one single query and When I run the code initially I’m getting “ORA-00933: SQL command not properly ended error. I ...