Stack Overflow
Stack Overflow

Questions tagged [delete-row]

Delete row refers to the removal of rows from a relational database.

The deletion can be achieved by using the DELETE statement of the SQL language.

1917 questions
4
votes
2 answers

Remove rows based on unique values across two columns

I got some data from two experiments where participants listened to pairs of audio, and now I'm trying to get a smaller list of pairs where the segments appear only once. Here is a sample of my data, where each row represents a pair: data <-…
DavidLopezM
  • 75
  • 1
  • 6
4
votes
4 answers

How to delete rows in hive hadoop database

I'm a newbie with hadoop & hive. I want to delete certain rows in my database - which is on hive-hadoop. I know its not supported out of the box, and that hadoop is a read only file system. I'm curious about what are the best approaches for…
Sunny
  • 369
  • 2
  • 3
  • 11
4
votes
1 answer

Deleting entire row from Cassandra counter column family

We have counter column family , something like that: create column family visits_counter_cf with key_validation_class =UTF8Type and comparator = 'CompositeType(LongType, LongType, UTF8Type)' and…
user3021296
  • 71
  • 3
4
votes
1 answer

Animation not working for UITableView deleteRowsAtIndexPaths:withRowAnimation:

[tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade]; This code (in the method commitEditingStyle) is not making any changes in animation when a row is deleted. The row gets deleted,…
funct7
  • 3,407
  • 2
  • 27
  • 33
4
votes
2 answers

Deleting rows cause lock timeout

I keep getting these errors when trying to delete rows from a table. The special case here is that I may be running 5 processes at the same time. The table itself is an Innodb table with ~4.5 million rows. I do not have an index on the column used…
Peter Lindqvist
  • 10,122
  • 3
  • 41
  • 60
4
votes
1 answer

"Deleted row information cannot be accessed through the row" trying to remove unused rows from my datatable

I'm grabbing data, sticking it into a DataTable, and displaying it in a DataGridView bound to that table. Im trying to make it so that data in the datatable that is not included in the current grab is deleted. I'm doing it as follows: public void…
MLavine
  • 195
  • 1
  • 5
  • 13
4
votes
1 answer

Deleting rows from two tables using inner join SQLITE

How do you delete a row from two separate tables? I thought it would be possible to do this using an inner join DELETE a.*, b.* FROM Holiday INNER JOIN Accommodation b on a.LocationID = b.LocationID Here i try to delete by matching the primary key…
user1992697
  • 315
  • 1
  • 5
  • 11
4
votes
4 answers

Delete a record from a view and from all its related tables

I am using SQL server Management studio 2008. I want to delete a single record from one of a view which shows null values in that record for all columns. I can't get to know,from which table i get this null record. I checked all the tables which are…
Hiral Bavisi
  • 91
  • 1
  • 3
  • 10
4
votes
3 answers

Why does this delete statement work?

Possible Duplicate: How can a SQL query have two from clauses? delete from machine_placement_group from (machine_group g left join config_chg_req r on g.machine_group_id = r.machine_group_id) join machine_placement_group mg on…
user1904985
  • 41
  • 2
4
votes
4 answers

Deleting rows in a table a chunk at a time

I have a single-column table Ids, which whose column ID is of type uniqueidentifier. I have another table MyTable which has an ID column as well as many other columns. I would like to delete rows from MyTable 1000 at a time, where the ID from…
Nick
  • 2,821
  • 5
  • 30
  • 35
4
votes
5 answers

VBA: Deleting Rows with a Specific Value

I'm trying to write a macro to delete all rows that have True in column A. Here is what I have so far: Sub deleteBlankRows3() Dim lastrow as Long Dim x as Long lastrow = 4650 For x=8 to x=lastrow If (Range("A1").Offset(x,0)…
Burton Guster
  • 2,213
  • 8
  • 31
  • 29
3
votes
1 answer

Delete a row from SQLite database by taking id from the populated listview

Individual rows in the database are populated in a custom listview. the id of the row is also displayed in the listview. All I want is to delete a particular row by clicking on the corresponding list. Here is the code I used to display the contents…
user1166422
  • 29
  • 3
3
votes
2 answers

Delete row from cursor source SQL Server

I have a SQL Server 2005 cursor operating over a table variable called @workingSet. Some times rows can be related and in this case I process the row I have fetched and the related rows at the same time. I then remove the related records from…
Simon Rigby
  • 1,786
  • 4
  • 17
  • 28
3
votes
1 answer

R: How to delete ID from a list of multiple strings in a longitudinal format

I had an earlier post regarding how to delete ID if any of the rows within ID contain certain strings (e.g., A or D) from the following data frame in a longitudinal format. These are R code examples that I received from the earlier post (r2evans,…
birch
  • 47
  • 5
3
votes
1 answer

cascade delete in android room database KOTLIN

There are a bunch of questions like this in StackOverflow but most of that arent about room database, so I had to ask a new question. I have an app that uses room database and that has near 4 tables and a big relationship between those tables, so…
Amir
  • 333
  • 4
  • 16
1 2 3
…
99 100