14,320 questions
0
votes
0
answers
59
views
Woocommerce blocks checkout: add dynamic text under shipping methods
I'm trying to add a simple text line directly under the shipping methods list, e.g. "Add x € to your basket to receive free shipping!" This will be shown only when shipping country is Greece ...
0
votes
1
answer
92
views
Python data values shift on right for multiple columns and insert function
I’ve attached an image of the dataset I’m currently working on in my Python notebook. I’m in the process of cleaning the data, but I’m stuck on a few rows where some values are misaligned — they need ...
- 1
0
votes
0
answers
148
views
Getting ORA-00942 error when running Insert Into
I am trying to insert data from a couple different tables in 2 different databases using database links. If I run the select query on it's own, it runs without error and returns the expected results. ...
- 21
0
votes
1
answer
85
views
Inserting records to two related tables at the same time with Hibernate
I was unable to insert data into two related tables at the same time. For example I wanted to insert 5 records into the pictures table and 1 record to the listings table at the same time.
I have the ...
- 9,085
1
vote
0
answers
67
views
Extremely slow DB insert using Turbodbc
I have built Turbodbc 5.1.2 from source with simdutf 7.3.0, Python 3.11. When trying to insert 150,000 rows of 46 columns to a MySQL 8.0 InnoDB table, Turbodb takes about 190s, compared to 15s with my ...
- 684
2
votes
1
answer
111
views
Impala INSERT OVERWRITE on Iceberg table does not remove duplicates despite using ROW_NUMBER()
I’m working with an Iceberg table in Impala named customer_fact, partitioned by the column created_at. The table contains duplicate rows based on customer_id, and I want to retain only the latest ...
- 21
3
votes
2
answers
73
views
Syntax `WHERE NOT EXISTS` using MySQL
This is my table tb_group on DB MySQL
_tdate
_tgroup
_tnumber
2025-05-12
71AB5
1
2025-05-12
71DB1
1
The values of columns _tdate and _tnumber of the table tb_group are obtained from a table where ...
- 131
0
votes
1
answer
79
views
MariaDB :Producing an insert from another table with concat
I want to produce an insert out of a table for another table with concat.
All works well, besides a little devil ...
At the end of the concat I get an ' after the ;
Without the ' it works all well.
...
- 119
1
vote
2
answers
174
views
Firebird insert record when not exists
If record number 21 does not exist in table1, create them from 21 to 30.
merge into table1 tab2 using table1 tab1 on tab1.number = tab1.number and tab2.number = 21 when not matched then insert (number,...
- 13
2
votes
5
answers
204
views
Laravel 9, Parent child bulk insert while replacing uuid to id
I have following table structure.
Table: movies
id
uuid
title
...
1
uuid-m01
movie 1
...
Table: categories
id
uuid
title
...
1
uuid-c01
category 1
...
2
uuid-c02
category 2
...
Table: movie_categories
...
- 2,055
1
vote
1
answer
42
views
in one column, several groups of hidden rows, insert new row and they all move down, how to stop?
I have several categories which I want the BTN_X to hide or unhide rows associated with each category. The code below works, but if i want to add an additional row (say add 217) in the first category, ...
- 11
0
votes
0
answers
36
views
Node.js / Sqlite 3: Alternative for INSERT query syntax
For every INSERT query (normally more columns and data entries) i am using this syntax
db.run(`INSERT into table1(column1, column2, column3) VALUES(?,?,?)`,
[data1, data2, data2], (err) =>...
- 3
0
votes
1
answer
67
views
ORA-1722 invalid number query
CREATE TABLE CAR
(
CAR_ID CHAR(5) PRIMARY KEY,
Serial_Number INT NOT NULL,
Make VARCHAR(20),
Model_Made VARCHAR(20),
Colour VARCHAR(20),
Year_Made INT,
Car_For_Sale ...
2
votes
0
answers
132
views
std::unordered_map::insert_or_assign - why there is another mapped type template defined?
I'm looking at the definition of std::unordered_map<Key,T,Hash,KeyEqual,Allocator>::insert_or_assign in cppreference, and in all signatures, there is template < class M >, standing for ...
- 69
-1
votes
2
answers
94
views
Understanding sys.schema_index_statistics
I am running a procedure that inserts 10,000 thousand records into a table. It's taking ages ( over 30 mins ).
The indexes on the table are the primary id and two other columns that are foreign keys. ...
- 35
0
votes
0
answers
201
views
Python insert values in DuckDB with lists off tuples
I am trying to add 2 lists to an INSERT command in Python.
I'm looking for the simplest smart method.
The DuckDb table is constructed with fields: Timestamp,Job, 10x real fields, 10x Boolean
I know ...
- 11
0
votes
1
answer
77
views
The parent attribute of the wp_insert_term function only works on one level
Would anyone have the solution to this problem that has been poisoning my life for 2 days already?
Here is my extremely simplified code:
<?php
// Creation of the first level: "niveau 0"
$...
1
vote
1
answer
43
views
Excel Table - Add a Row Formulation
The table starts at B7 and ends at B5 on the left and on the right starts at AA7 and ends at AA26. I want the "add row" button to add a row with the same formulas as in the rest of the table....
- 11
-2
votes
1
answer
97
views
Inserting a field with find and replace in a word document
I've got a bunch of regulations, and I have a regular expression that finds them. They all look like "28-35-###(sometimes letter here)". I have all of them as bookmarked as the text ...
1
vote
0
answers
68
views
Mysql generate uniqueid when id is NULL
So I have a project where I am indexing inventory items by upc barcode values. My inventory table has the primary unique column upcID, the column is not auto-incremented. On instances where I scan ...
- 11
0
votes
1
answer
75
views
Excel VBA Insert Column when Value Changes and add formula
Through VBA I want to compare hotel rates between operators.
the Top image is how it is pulled
the bottom image is the final output desired
I want to Insert a column each time the HOTEL changes.
Then ...
- 103
0
votes
2
answers
129
views
Auto Insert row and insert Total and sum using Excel VBA
I want to insert total in the rows based on the Serial Number in Row A starting from Row 6. There are more than 5000 rows in a sheet.
When there are two serial numbers like in this example A15 and A16,...
0
votes
0
answers
71
views
How do I take the results of a CTE and Pivot table and insert into a table or temp table [duplicate]
This is my Sample the data has "|" delimiter's and 46 column's of data there are 3 gigs of records in this format.
DECLARE @myString AS nvarchar(2000) = 'FRED|Flintstone|Stone age|m'
;...
2
votes
4
answers
130
views
Insert block of text at beginning of a file
I've seen a number of posts about injecting single lines at the beginning of a file. However, I haven't really any that answer to injecting a block of text into the beginning of an existing file. ...
1
vote
1
answer
96
views
Inserting multiple items of data into tables and a unique ID into a table along with a query
I'm trying to capture data from a query and save it all into Table1. I created another table2, too, for a one-to-many relationship.
The setup is this - Table1:
Capture_Num
Capture_ID
F3
F4
F5
Table2 ...
- 11
0
votes
0
answers
29
views
replace values of a column (but keep NA values) with list of other values python [duplicate]
I would like to start since I am looking for tips on how to tackle this issue, rather than specific code with an answer I have not provided any code, just my situation. Is this allowed? Or am I still ...
- 3
0
votes
1
answer
202
views
How to get ID of last inserted or updated row when using $wpdb->query
I am inserting data in a Wordpress plugin table using a custom query using the $wpdb->query() method. I use a custom query because I need to run ON DUPLICATE KEY UPDATE. Is there a way to retrieve ...
- 229
0
votes
1
answer
108
views
Split a .table.sql script into multiple files
I have generated a file with schema and data of a table. The file is huge, so I need to split it in several files, no editor can open it.
I have tried Ultra Edit but the files appeared truncated
I ...
0
votes
2
answers
41
views
TCL - A condition for an item while appending items to a list
I have this list
set csv [list]
lappend csv [list \
a \
b \
c \
[expr {[cfg::get enable_all_columns]
? {
d
}
: {}
}] \
e \
f \
g]
I need to add element d only if enable_all_columns is 1. The problem ...
- 1
0
votes
1
answer
66
views
TCL - adding elements to a list with { }
I have a list of this form {a b} and I cannot insert anything inside the curly brackets
I tried these:
set csv [list]
lappend csv [list \
a \
b]
set csv [linsert $csv 1 x]
puts "$...
- 1
-2
votes
1
answer
50
views
Insert ignore into database coping old record and changing 1 field in new record [duplicate]
$sql = {"INSERT IGNORE INTO membership WHERE Member_id= 'A4C1905' (`Name`,`GivenName`,`SpouceName`,`SpouceGiven`,`Address`,`City`,`Prov`,`PostalCode`,`Phone`,`Email`,`Secondary Email`,`Region`,`...
0
votes
1
answer
107
views
Insert Elements into XML code in the proper order/sequence? Python code
I am new to Python and I am attempting to create a script that will open an XML file and insert an XML element into the proper place within a sequence of XML elements.
So far, I have this code:
import ...
- 3
0
votes
2
answers
76
views
Using JavaScript how do I enclose the text of an <a> tag with a <span> if a parent <div> has a certain class
I have the following code
<div class="team-grid">
<div class="cssgrid-wrapper">
<div class="cssgrid-container">
<div class=&...
- 13
-1
votes
1
answer
88
views
Kotlin Android SQLite INSERT INTO query increment row count, but values are not inserting
I am trying to insert a row of values in to SQLite database. The row count value return from insertorThrow function is higher than -1 and its incrementing each time. There is no error from SQLite ...
- 1
0
votes
0
answers
32
views
SQL Server Populate Local Table with Exec call [duplicate]
I have a very complex SQL Server procedure and the folks requesting the changes asked for additional data that comes from a secondary complex procedure. I am attempting to do the following:
In ...
- 765
-1
votes
1
answer
53
views
using SELECT * INTO to duplicate a record into another database [duplicate]
I am trying to duplicate a table from one database into another database. The original table contains static data. I need to be able to manipulate the data in the 'copied table'. This process needs to ...
- 3
0
votes
1
answer
51
views
Trying to add an html sidebar that will add images picked from a list
So I want a sode bar pop-up thats just a list of buttons with different names, and you click on a button and it inserts the named image. I have a script that sucessfully adds an image, and I have a ...
- 1
2
votes
2
answers
335
views
How to insert an ObjectId into a document in mongo and golang
I'm having a problem inserting an ObjectId into a doc.
this is the collection sale model
type Sale struct {
ID primitive.ObjectID `bson:"_id,omitempty"`
Client primitive....
- 23
0
votes
3
answers
119
views
Batch insertion into multiple tables based on a single result set
I have written a computationally expensive select query which produces a certain result set. I need to insert this result into a table and the aggregates of this result set into another table. I need ...
- 161
-1
votes
1
answer
316
views
Cant Insert Data from Nested Json in Clickhouse
I have some json file, i save in s3, the structure is like this
{
"testing_field": "tambahan",
"test_update_2": {
"code_1": "5B72F80DA8",
&...
0
votes
0
answers
322
views
insert(classObject) for SwiftData add & update, both?
Very simple SwiftUI/SwiftData app below to demonstrate concepts. I've been using the same DetailView to handle add & update in SwiftData. Using modelConext.insert(person) seems to handle BOTH ...
- 2,061
0
votes
0
answers
93
views
MariaDB Is there a syntax to update the values with ONDUPLICATE without having to rewrite all columns
I have to update a existing record e.g.
INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3)
ON DUPLICATE KEY UPDATE
column1 = VALUES(column1),
column2 = VALUES(...
- 1,258
0
votes
1
answer
363
views
INSERT in for loop on a in-memory DuckDB?
Doc says:
If you must use INSERT statements to load data in a loop, avoid
executing the statements in auto-commit mode. After every commit, the
database is required to sync the changes made to disk ...
- 16.1k
1
vote
0
answers
72
views
MySQL insert ignore is still inserting duplicate values
I am reading columns/values (which could have dozens of duplicates) from TableA and need to insert unique records into Table B. Table B is an empty table, has a primary key and has a 5 column unique ...
- 3,194
1
vote
1
answer
221
views
While executing Insert Statement in Snowflake getting error
I was doing Badge 3 in snowflake university and getting error. ESS-DABW Badge 3: Data Application Builders Workshop: Lesson 5: Pending Orders App Improvements 🥋 Perfecting the ORDERS Table ...
0
votes
1
answer
801
views
Snowflake - Simultaneous inserts into the same table - Will they be in multiple independent partitions OR 1 common partition?
In Snowflake, I am planning to run multiple INSERT statements into the same table simultaneously. An example could be batch INSERT 10 million records for 1 date, and batch INSERT 10 million records ...
- 59
1
vote
1
answer
183
views
How is the insert operation in a B-Tree O(log n), should it not be O( log 2d -1 ) where d is the degree of the B-Tree
A search operation in B-Tree can be O(logn) because we can perform a binary search on the key we are looking for at any node. When inserting a key in a B-Tree node which isn't full and is the leaf ...
- 722
1
vote
1
answer
81
views
Powershell insert CR in massive array
I have a massive array of string characters that I would like to insert a carriage return every 10 characters.
For example, if my string array in Powershell is:
all_str_data = ...
- 17
-1
votes
2
answers
57
views
Unable to add a column named 'Investor Type'
I have a dataframe which has 500 rows * 454 columns. I want to add a column that says 'Investor Type' after every column that says 'Description'.
So the data frame column labels look like this:
Annual ...
0
votes
1
answer
119
views
Security.stripInaccessible() remove a field that I need
This method is removing a field that I need to make the upsert, is a field that isn't writable but is stuffed in the code.
if(customFee.orderFee.Quote__c == null){
customFee.orderFee.Quote__c =...
