14,320 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-3
votes
0
answers
123
views
Can't add row to bottom of table when another specific table is below it |VBA
UPDATE: Thanks everyone i managed to fix it by just temporality moving the table 2 out of the way and moving it back.
I'm making a small personal project and for some reason, when I add a certain ...
0
votes
0
answers
68
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
94
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 ...
0
votes
0
answers
149
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. ...
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 ...
1
vote
0
answers
68
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 ...
2
votes
1
answer
112
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 ...
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 ...
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.
...
1
vote
2
answers
179
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,...
2
votes
5
answers
205
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
...
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, ...
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) =>...
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 ...