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
14
votes
6 answers

How to remove row in 2d array in javascript

How to remove row in two dimensional array in JavaScript with row number. If I want to delete all elements in row number 4 then how can do it??
Rajani Rampelli
  • 179
  • 1
  • 1
  • 12
13
votes
5 answers

crash on deleteRowsAtIndexPaths

My application crashes when I'm deleting row from table. Here is my sources where the bug is detected and stack trace. Thanx! //delete row from database - (void)tableView:(UITableView *)tableView…
yozhik
  • 4,644
  • 14
  • 65
  • 98
13
votes
3 answers

Remove duplicate rows leaving oldest row Only?

I have a table of data and there are many duplicate entries from user submissions. I want to delete all duplicates rows based on the field subscriberEmail, leaving only the original submission. In other words, I want to search for all duplicate…
RB. J
  • 259
  • 1
  • 4
  • 10
13
votes
2 answers

Deleting a Row from a Time Indexed Dataframe

I'm trying to delete a row in a Pandas dataframe by simply passing the date and time. The dataframe has the following structure: Date_Time Price1 Price2 Price3 2012-01-01 00:00:00 63.05 41.40 …
Markus W
  • 1,451
  • 5
  • 19
  • 32
13
votes
2 answers

How to delete a row in a Pandas DataFrame and relabel the index?

I am reading a file into a Pandas DataFrame that may have invalid (i.e. NaN) rows. This is sequential data, so I have row_id+1 refer to row_id. When I use frame.dropna(), I get the desired structure, but the index labels stay as they were originally…
user394430
  • 2,805
  • 2
  • 28
  • 27
12
votes
2 answers

SSIS - Delete rows

I'm new to SSIS and need help on this one. I found an article which describes how to detect rows which exist and which have changed. The part that I'm missing is how to update rows that changed. I found some articles which say that it's also good…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
12
votes
4 answers

Check if a row could be deleted in MySQL

Is there a way I can check if a row potentially could be deleted? That it for example is not currently connected through restricted foreign keys to anything else. Reason: I am making an admin page with all the users in the system listed. They can…
Svish
  • 152,914
  • 173
  • 462
  • 620
11
votes
8 answers

How to delete a row from GridView?

I am using GridView control in asp.net 2005 c# using . How can I delete a particular row from GridView. I have written the following code. But it's not working... DataRow dr = dtPrf_Mstr.NewRow(); dtPrf_Mstr.Rows.Add(dr); GVGLCode.DataSource =…
Kartik
  • 611
  • 5
  • 17
  • 31
11
votes
1 answer

AttributeError: 'numpy.ndarray' object has no attribute 'drop'

I'm trying to delete the first 24 rows of my pandas dataframe. Searching on the web has led me to believe that the best way to do this is by using the pandas 'drop' function. However, whenever I try to use it, I get the error: AttributeError:…
RockAndaHardPlace
  • 417
  • 1
  • 7
  • 18
11
votes
1 answer

Delete ROW where Value in column is NULL

How do I delete out any rows from a table named: bhxsql2014-dev.dbo.EUACTIVESTORES Where the column [Store No] has a NULL value I'm using MS SQL Server Management Studio
Quacks101
  • 293
  • 1
  • 3
  • 12
11
votes
4 answers

how do I delete rows in Yii?

Using Yii, I want to delete all the rows that are not from today. Is my solution ok ? $query = "delete from `user_login_hash` where `day`!='".(date('Y-m-d',time()))."'"; Yii::app()->db->createCommand($query);
Ionut Flavius Pogacian
  • 4,750
  • 14
  • 58
  • 100
10
votes
4 answers

delete rows from multiple tables

I'm trying to use SQL to delete multiple rows from multiple tables that are joined together. Table A is joined to Table B Table B is joined to Table C I want to delete all rows in table B & C that correspond to a row in Table A CREATE TABLE `boards`…
AdRock
  • 2,959
  • 10
  • 66
  • 106
10
votes
1 answer

Delete Single Object Data /Row from Realm in android

I added a data of single User Like this : Realm realm = Realm.getDefaultInstance(); newUser = new UserDatabase(); realm.executeTransaction(new Realm.Transaction() { public void execute(Realm realm) { newUser.setClassName(classSectionName); …
erluxman
  • 18,155
  • 20
  • 92
  • 126
10
votes
3 answers

UITableViewCell, show swipe-style delete button without swipe

I search couple of article but I didn't find what I'm looking for. Basically, I want to show delete button on each row but I don't want use UITableView.editing property. Because it looks like this; There will be "Edit" button. When user click on…
Göktuğ Aral
  • 1,409
  • 1
  • 13
  • 28
10
votes
3 answers

When I remove rows in Cassandra I delete only columns not row keys

If I delete every keys in a ColumnFamily in a Cassandra db using remove(key), then if I use get_range_slices, rows are still there but without columns. How could I remove entire rows?
Matroska
  • 6,885
  • 14
  • 63
  • 99
1 2
3
…
99 100