Questions tagged [sql-delete]
The SQL DELETE statement allows you to delete a single row or multiple rows from a SQL table.
sql-delete
3,119
questions
0
votes
0
answers
22
views
Delete operation taking time from SQL Agent Job [migrated]
I am running a job which deletes data from 7 tables, 2 of which contains 10-20 lakhs of records. But the job get stuck at a point when deleting data from a particular table web_activity which holds ...
- 1
1
vote
0
answers
80
views
Optimizing of a MariaDB DELETE query in a big table
I am using MariaDB 10.11 on Linux.
I have the following table that is supposed to get about 40 inserts per second and about 40 deletes per second.
It contains trade data and is used to generate stock ...
- 65
0
votes
0
answers
24
views
Sequelize SQLite Delete Not Working - Table Not Found Error
I have a React+Node Web app, and I cant't figure out why the delete is not working, Create, Read, Update work well, I have tested with Postman
The error I get is:(put the one from the server)
...
- 1
0
votes
3
answers
49
views
Executing stored procedure delete all rows from table despite WHERE clause setting
I created this little stored procedure that deletes a row from my 'qrcode' table.
Due to the constraint, I update all child rows before, it works fine.
However, performing this procedure....deletes ...
- 777
0
votes
1
answer
218
views
Salesforce - Duplicate value found error while trying to delete a record
We are getting an error while trying to delete a record in an Apex class. I have gone through some research for this error (listed below). However, these examples talk about this error while doing an ...
- 3
0
votes
0
answers
26
views
Fetch method delete react
I need help when clicking on my icon the corresponding message deletes it
I can't get my route to work on the front side
mon code front
const handleTrash = (id) => {
fetch(`http://localhost:...
0
votes
1
answer
75
views
MySQL optimize a SQL for a table without indexes
The metadata table of Spring Batch will not be automatically cleaned,
so I tried to clean it manually (provided that other batches processes are executed normally during the cleaning process).
When I ...
- 13
1
vote
1
answer
175
views
How to parallelize SELECT and DELETE?
In PostgreSQL I have to fetch ids in small batches and delete them at same time, so that no 2 clients will fetch same ids.
Sadly, DELETE does not support LIMIT, so I came up with this query:
DELETE ...
- 3,132
-1
votes
1
answer
40
views
Delete rows from a parent table without affecting the condition table
I have a main table and a secondary one. Through a query I connect the secondary with the primary on the left, to filter the results of the primary. PhpMyAdmin disables editing and deleting the ...
- 19
-1
votes
2
answers
25
views
Deleting rows found with left join on SQL
I am using this query to show all the departments and their managers, including the departemnts with no managers, that's why I am using left join. Now I need to delete the departements where there is ...
0
votes
1
answer
45
views
Asking for advice on debugging a not-working JPA delete call
We're having a rather complex table structure in our Spring Boot application, consisting of about ten entities linked by one-to-one, one-to-many, many-to-one and many-to-many relations. They're ...
- 2,023
-2
votes
1
answer
47
views
Can't display in index.php my data table when items are deleted [duplicate]
I have a form and I connected with MySQL, so whenever I fill it up it will be shown in mySQL. The next step is to have a table of contents in my index.php, which I have. But now when I wanna press the ...
- 1
1
vote
1
answer
81
views
AFTER DELETE trigger fires only if a DELETE is executed on a db query but not on EF Core
I have two master-detail tables with a one-to-many relationship. I want to let a trigger fire after a deletion has happened, whether it has been as a cascade action (deleting the master by its PK) or ...
- 182
1
vote
1
answer
32
views
PostgreSQL doesn't take into account a DELETE in WITH before the request has ended
I have two tables to handle attachments:
"files" which contains an id and other info
"attachments" which contains the id_file (the id in the table files is the foreign key) and ...
- 2,092
0
votes
1
answer
63
views
Why Postgres does not delete rows if one of the columns is NULL when USING/IN/EXISTS is used? [duplicate]
Let's say we have a table:
CREATE TABLE rows(
a int NOT NULL,
b int,
c int
);
INSERT INTO rows(a, b, c) VALUES (1, 1, NULL), (2, NULL, 1), (3, 1, 1);
Why Postgres does not delete the row using ...
- 117