Questions tagged [delete-row]
Delete row refers to the removal of rows from a relational database.
delete-row
1,917
questions
0
votes
0
answers
21
views
2 colums in a child table have foriegn key relation with same parent table how to delete them using cascade in spring boot domain class
//Parent class
Class parent
{
String id;
@OneToMany(fetch = FetchType.LAZY, mappedBy = "parent1", cascade = CascadeType.ALL)
private Set<child> groupMembers = new HashSet<...
0
votes
1
answer
61
views
Supabase delete not working through javascript client api and postman
I'm trying to delete a row in a supabase table via the javascript client api (also tried postman later). Supabase is running on a remote server via docker. I'm working with Next.js, but all cache has ...
1
vote
1
answer
43
views
Delete from same table using inner join seems to be failing (both records removed)
I have a table which has both ChildID and ParentID. Due to the way the data was compiled, in some cases those values are reversed. So I wrote what I thought was a simple Inner Join where both values ...
- 515
0
votes
1
answer
54
views
Entity Framework Core v7+ : execute delete on foreign key related tables without navigation property
I have a following two tables each with millions of record so performance for delete is needed
Table Product
(
DateOf date not null,
Type varchar(100) not null,
ProductId int not null,
...
- 13
0
votes
0
answers
37
views
New to stored procedures; need help in creating procedure
I am new to procedures and trying to create a procedure to delete entries from tables.
Tables names will be in query 1. My request_id will be in another query which entries I need to delete.
How do I ...
- 1
0
votes
0
answers
27
views
MySQL: How to make a trigger that updates a table after a deletion in a related table?
I have a database with 2 relevant tables: animals and movement. The movement table tracks animal movements. The animals table has animal_id as the primary key, and which is a foreign key in the ...
- 1
0
votes
0
answers
13
views
Remove one parent record which has two parents records
I have a table which ended up with ParentIDs incorrectly created so that some records are on the same levels as ones which their parent record. For simplicity sake:
Name
Parent
Son
Father
Grandson
...
- 515
0
votes
0
answers
21
views
How do I delete contact use contentResolver in android?
I'm a beginner in Android and I'm having a problem with this code. When I run it, it can only delete the contact's phone number but can't completely delete the contact. How do I fix it? Please help me....
0
votes
2
answers
40
views
How to delete a specific line containing a file path from a text file in Linux using a variable with this path? [duplicate]
I need to delete a specific line from the fstab file, given the Mountpoint in $MOUNTPOINT variable:
So, I have this variable:
MOUNTPOINT=/mnt/my_lvm_partition
when I tried to find it in fstab file:
...
- 59
0
votes
0
answers
48
views
VBA Delete Rows in sheet where formulas go to row 1000, then insert rows at bottom and copy formulas to new rows
I have a script that deletes rows based on a status cell in each row, then subsequently inserts new rows (same row count as those deleted) to the second to last row in the sheet. I am running into a ...
0
votes
1
answer
38
views
for issuing in cbt CLI 'cbt deleterow <rowkey>', how can i escape space character in a rowkey?
Please if anyone knows how to get succeeded on that :
I have to get rid of a set of rows in a bigtable. Their rowkey contains SPACE characters.
i am trying to escape those space characters but I´m ...
-1
votes
1
answer
52
views
Deleting lines in sheet based on text in one column in VBA
I currently have a macro set to delete lines I no longer need as a start:
Sub JSAidRun()
'
' JSAidRun Macro
'
'
Range("1:1,2:2").Select
Range("A2").Activate
Selection.Delete Shift:...
0
votes
1
answer
363
views
How to Delete Multiple Rows in Power Apps Data Table
I have a Power Apps Data table and this data table retrieves my SharePoint list [Vacation Budget] records. I have already removed multiple records in the data table using the RemoveIf function based ...
- 27
1
vote
1
answer
48
views
Remove a portion of String after certain value
I am using below mentioned code for finding a string in a file(Constants.TcGVL), assign my desired value(%select%) to it and copy to a new location:
Call :ValueSubstitude "%root%\LeafSpring\...
- 11
0
votes
1
answer
51
views
Google sheets script is erasing formulas in columns I don't want deleted or cleared
I'm stuck in a very annoying situation, I have a script for google sheets we’re I have two sheets out of several others in the workbook, the script would email one sheet "Pedidos" as an ...
- 3