Questions tagged [insert]
A core statement in SQL that does what it says on the tin: inserts data into a table.
0
votes
1answer
24 views
Trouble updating column with matching data from another table (3 diff. attempts: 1 w/out errors but no results, 2 with errors I don't understand) [on hold]
Table 1 is 'z_scrapestorm_rentals' and table 2 is 'pcpao_cols'. They both have address columns named 'address_1_line_trunc' and 'address_one_line' respectively.
Table z_scrapestorm_rentals:
column ...
0
votes
0answers
29 views
PostgreSQL occasional slow insertion speed because of FK trigger
I have two tables in master-child relationship (several children per master).
In one use-case a master with all of its children needs to be copied as new master. For this I'm using two select+insert ...
0
votes
1answer
34 views
Postgresql 10 There is no unique or exclusion constraint matching the ON CONFLICT specification
I currently have a table which looks like this:
CREATE TABLE "PDPC".collection
(
col_no bigint NOT NULL DEFAULT nextval('"PDPC".collection_col_no_seq'::regclass),
q1 character varying(10000) ...
6
votes
1answer
147 views
Error 666 on clustered primary key
I am receiving error 666:
the maximum system-generated unique value for a duplicate group was
exceeded.
I am experiencing this on an Azure SQL Managed Instance.
However, I shouldn't be getting ...
3
votes
0answers
16 views
On the INSERT statement in H2, what does `DIRECT` mean?
I noticed on the grammar documentation for INSERT in the H2 Database Engine, the optional word DIRECT. The documentation says:
When using DIRECT, then the results from the query are directly ...
0
votes
0answers
41 views
Slow insert on very large tables, (even in transactions)
I have a table with about 50 million rows, the table itself is fairly simple
CREATE TABLE Word (id integer PRIMARY KEY, word TEXT UNIQUE)
I then do an insert
INSERT OR IGNORE INTO Word (word) ...
0
votes
1answer
27 views
Map auto increment ids on multi-row insert
I have the following table with an AUTO_INCREMENT column.
CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);
Usually I load multiple ...
0
votes
1answer
32 views
Inserting into table depending on conditions [closed]
I'm trying to insert data into table but depending on the content it is supposed to be done different ways. My question is whether there exists such function that will work like follows:
WHEN ...
-1
votes
0answers
22 views
Partitioned table does not return number of rows inserted successfully
Recently we partitioned out postgres tables and when we run the insert query to this partitioned table, postgres does not return number of rows inserted. Is this an expected behavior of postgres, if ...
0
votes
2answers
43 views
INSERT AFTER trigger failing with multiple rows
I have a trigger (AFTER INSERT) that has been working in single inserts, and I believed it would work for multiples but its not. I researched it and am currently stuck as what I'm reading implies it ...
1
vote
2answers
90 views
Insert sometimes takes more than 2 seconds in table with +6 million records
I have a table in my database that acts like a log to record accesses to some selected endpoints of my application.
That table contains:
id (primary key)
The http method (GET, POST, PUT, etc)
The ...
0
votes
1answer
27 views
How to insert data in table with constraint on column? - in parallel queries
I have an Oracle database with a table with a unique field in it:
create table t(n number, CONSTRAINT n_unq UNIQUE (n));
Then from a session-1 someone is trying to insert some data:
insert into t(n)...
0
votes
1answer
46 views
What is the best way to check if a value in a table has changed when writing to a database?
Let me provide you with an example. Let's say I have an html_tag with two columns, tag_type and tag_value
For example, let's say I have a record with the value "link" under thetag_type field and "...
2
votes
2answers
54 views
Insert/update data into relational database tables only after administrator approval - how to approach it?
I'm building a relational database that holds 21 tables, which is connected to my website application through PHP.
The website has search functionality which allows users to search this database. ...
0
votes
1answer
20 views
Need some insights on 'index_page' variables in Innodb_Metrics Table
I was experimenting with page-split behaviour for sequencial vs random ordered inserts in Mysql,Innodb.
For sequencial Inserts I got:
index_page_splits: 3199
index_page_merge_attempts: 0
...
-2
votes
2answers
92 views
How to UPDATE along with INSERT INTO SELECT [closed]
I added some entries from table2 to table1 as
INSERT INTO table1 (title) SELECT title from table2 WHERE ...
how can I UPDATE table2 for the SELECTed or INSERTed entries as
UPDATE table2 SET status='...
0
votes
1answer
26 views
How to accomplish such insert-or-update strategy?
Programming stored procedures isn't my strongest point when it comes to programming, but I'm trying to get better.
I've stumbled upon a business requirement that's kind of hard for me and I was ...
0
votes
0answers
16 views
How works the flash recovery area
Im working with QGIS and Im trying to save a Mapinfo map to Oracle Spatial. The map file is around 1GB and has 700k road segment.
The issue is when copy the segements from the source map to the db ...
0
votes
1answer
23 views
In which context does a procedure run when called from another context?
Envisage:
use databaseA;
go
exec databaseB.dbo.spProcedure();
go
Does the procedure execute against databaseA - the context from which it is called, or databaseB - the context in which it exists?
...
1
vote
0answers
20 views
How to insert static strings appended to incrementing numbers into database column? [closed]
I'm pretty new to SQL so not too familiar with queries outside normal SELECT, INSERT, etc. But I'd like to pre-populate a column with values of the form FBxx (i.e. FB00, FB01, FB02, FB03..., FBFE, ...
0
votes
1answer
26 views
Get result from select exists, execute insert query based on the response of it
I have to insert unique value for a row but has to put check on 3 columns collectively ((unique value(col1 && col2 && col3) == true)
I found a solution here it is
query = select ...
1
vote
1answer
102 views
Insert Trigger to a Linked Server error
I created an insert trigger in a table that will fire when an insert/update/delete is made. The trigger is supposed to send information about the query that fired it, but every time it fires, the ...
1
vote
1answer
55 views
How to perform multiple inserts into postgresql database in one query
I have an orders, recipient and items tables.
I want to insert data into each of these tables based on the response from the previous query.
insert into recipient(name, address) values(name, address)...
0
votes
1answer
35 views
INSERT INTO statement with select
I am trying to insert a new record into a table, but only if another record of the same table meets some conditions. Sadly it does not work I alwys get the following error: ERROR: duplicate key value ...
0
votes
2answers
47 views
ORACLE Table insertion
I want to insert data into below table, but I got an error. How do I solve this?
CREATE OR REPLACE TYPE TEST_TYP FORCE IS OBJECT ("id" VARCHAR(5000 NULL) NOT FINAL;
CREATE OR REPLACE TYPE TEST_TAB ...
0
votes
1answer
39 views
How to use the result of an insert as foreign key in another insert?
I have a temporary table with lots of data. I want to populate two persistent tables with excerpts of that data, preferably in one go.
Problem: after insert on tableA, I want to reuse the generated ...
0
votes
1answer
49 views
MySQL: Trying to “normalize” data using MySQL to help
I inherited a spreadsheet with 1600+ records, which I simply inserted into a single table (mapping) in MySQL.
I'd like to use the power of MySQL to help me do some "normalization", à la the MySQL ...
0
votes
1answer
238 views
How can you insert data into a ARRAY column on a Snowflake table using SQL?
I am having difficultly finding documentation on how to insert data into an ARRAY column type using SQL on a Snowflake table.
Snowflake Documentation: https://docs.snowflake.net/manuals/sql-reference/...
0
votes
2answers
23 views
How do I end function when X
so my function looks like this:
create or replace function insert_stuff(a1 text, a2 text, a3 int)
returns table (id_i int, id_j int) as
$$ begin return query
with
i1(id1) as select insert_here(a1,a2)...
-1
votes
0answers
14 views
Get the syntax that fired an insert trigger [duplicate]
Is there a way for an insert trigger to get the line that caused it to activate?
0
votes
1answer
72 views
How can I subtract two row's values within same column and then insert random values between the two rows if the difference > 30s?
Here is my question:
This is a table in SQL Server 2012:
,then I should calculate the differences of WRTime between the adjacent two columns. If the difference > 30s, I should insert some random ...
2
votes
1answer
220 views
Error while inserting into array of timestamps
Im using postgres 10.1 and the Datestyle config is the following
DateStyle
-----------
ISO, MDY
Im having this error
ERROR: date/time field value out of range: "1535673858" Hint: Perhaps
you ...
5
votes
2answers
2k views
Inserts in MySQL 8 are slower than Inserts in MySQL 5.7
I've started to use MySQL 8 (8.0.12), and I'm realizing that the "inserts" are slower in this version than MySQL 5.6 or MySQL 5.7. It doesn't matter if the table is MyISAM or InnoDB, with just one "...
0
votes
2answers
121 views
MySQL 5.1 - long running select locking the table and not allowing inserts
Platform - MySQL 5.1, MyISAM engine
We reached max on int (id, auto increment) in our Prod system. Changed the type to BigInt. Even since this change was made, long running selects are locking the ...
2
votes
0answers
92 views
SQL Server: INSERT-SELECT Statement occasionally fails silently and works upon re-run
We have a batch import process that BULK INSERTs raw data into staging tables, does some data mapping, and then pushes it to another database for validation.
The procedure where my issue occurs is ...
3
votes
0answers
61 views
Where is Newid(), Rand(), and Sysutcdatetime() new value per query vs. row behavior documented? [duplicate]
Within a single query, all current time functions like sysutcdatetime() return a single point in time that is re-used throughout the query for each instance (e.g. of sysutcdatetime()) no matter how ...
0
votes
3answers
463 views
Insert Values Into Table, Putting Duplicates In Another Table
So I posted this question yesterday. Some of the responses I got were helpful, however it seems my issue is a bit more complex than I originally thought.
After doing some looking the reason I was ...
1
vote
2answers
305 views
Insert into Table ignoring duplicate values
I am having a brain fart on figuring this out. I have the following two Tables:
Table: parts
part_id INT IDENTITY(1,1) NOT NULL,
part_number VARCHAR(50) UNIQUE NOT NULL,
...
1
vote
1answer
58 views
Innodb updates records with delay
I have two tables in my database like these:
CREATE TABLE `main` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ...
0
votes
1answer
25 views
unable to add data to table because related record is required
I have an access database with my work that I am trying to insert into but I keep getting.
'You cannot add or change a record because a related record is required in table 'Projects'.'
I'm running ...
1
vote
1answer
35 views
What data is duplicated when MySQL/MariaDB BLOB columns are copied?
Let table_1 be created as follows:
CREATE TABLE table_1 (
id INT AUTO_INCREMENT PRIMARY KEY,
some_blob BLOB
);
Let table_2 be created as follows:
CREATE TABLE table_2 (
id INT ...
0
votes
1answer
676 views
Insert into DB2 table a result from temp table
Is there a way to insert a temp table results to DB2 table, for example:
WITH TEMP1 AS (
SELECT CUSTOMER_ID
FROM T_CUSTOMER WHERE CUSTOMER_ID BETWEEN 100 TO 300
),
TEMP2 AS (
SELECT CUTOMER_ID, ...
1
vote
1answer
81 views
How to create `instead of` trigger on a table in postgres?
I want to create a trigger for a table in postgresql. My table contains data about events and includes room number, start time and event duration. Upon new insertion to the table I want to check if ...
1
vote
3answers
414 views
How to ensure data isn't inserted into a table where the data already exists?
I've created a query which I want to insert the results into another table. It is going to be ran as a job every day, and data imported will still be kept in the result set. I don't want the data to ...
2
votes
2answers
31 views
Function Isn't Excluding Repeat Data
I am trying to insert a large amount of data into a table. The source for the data has the potential to repeat data in what is suppose to be a UNIQUE column. I created the following to insert the ...
1
vote
0answers
30 views
Long INSERT on large table blocks INSERT on other tables
Server is MySQL 5.7 and the tables are InnoDB. The large table consists of 20+ GB of data. The large table has several indexes on it and also full_text_indexes!
Use-Case explained:
There are ...
2
votes
3answers
727 views
Insert Into Multiple Tables At Once
I am migrating data between two databases. From the first database I am exporting a csv file that has the following columns:
Customer_Name
Contact_First_Name
Contact_Last_Name
Phone1
Phone2
Fax
I ...
0
votes
1answer
26 views
Can I somehow group insert returnings?
I am trying to insert user and multiple of his user role + return id of created user in single row. I used following query:
WITH inserted_user as (
insert into "user" (username, password, nickname, ...
0
votes
1answer
92 views
Insert Into Existing Table Using OpenQuery
I am attempting to insert data into a linked server using openquery. I have attempted the below syntax, but get an error of
Cannot get the column information from OLE DB provider "MSDASQL" for ...
0
votes
0answers
20 views
Finding rows affected by deadlock on page locks [duplicate]
We've got a db that has been pretty much deadlock free for over 6 months, but a day or two ago we had over 60, all on the same two or three pages of the same table (~12,000,000 rows, ~250 bytes per ...
