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
3
votes
2 answers

Delete Column Rows with Any Numeric Substrings

I notice that when an element of a column from a Pandas DataFrame has numeric substrings, the method isnumeric returns false. For example: row 1, column 1 has the following: 0002 0003 1289 row 2, column 1 has the following: 89060 324 123431132 row…
spacedustpi
  • 351
  • 5
  • 18
3
votes
1 answer

Retrieve deleted rows on deletion

Is there a way to retrieve the rows deleted when calling Delete()? I'd like to avoid using 'SELECT ... FOR UPDATE' to first get the list of rows I'm deleting. type MyModel struct { gorm.Model .... } res := db.Where("updated_at < ?",…
lilorox
  • 155
  • 2
  • 12
3
votes
1 answer

Delete current iterating row from CSV file in PHP

I want to delete current iterating row from CSV file, Suppose I have 5 rows (1,2,3,4,5) into my CSV file, I opened my file while iterating the rows one by one using foreach, when it comes to 3rd row then 3rd row should be deleted from CSV file and…
Naveen
  • 41
  • 8
3
votes
2 answers

Oracle global_names DELETE problem

I'm using a database link to execute a DELETE statement on another DB, but the DB link name doesn't conform to global naming, and this requirement cannot change. Also I have global_names set to false, and cannot be changed either. When I try to use…
jyz
  • 6,011
  • 3
  • 29
  • 37
3
votes
3 answers

Pandas delete rows if value is same for certain date range

I tried looking up for something similar but could find it. So I have below structure dataframe. I looking to delete rows that have same score for 5 days or more. So in below case PeronID AB-123's records from 2/1 to 2/6 needs to be deleted, also…
PyRaider
  • 607
  • 4
  • 11
  • 21
3
votes
1 answer

Deleting rows breaks merged cells

I'm delete some row, and address of merged cell after this row is wrong. For example, there are merged cells "A78:C78". If I do worksheet.DeleteRow(5) Address of worksheet.Cells[77,1] is "A77". But worksheet.MergedCells[77,1] is null, but it…
Alexander Kotelnikov
  • 33
  • 3
3
votes
1 answer

SQLite delete shared row when last reference to it deleted

I read the documentation for cascading delete, but one thing I'm not clear on is if it's possible to set up a database so that a child row can be shared by more than one parent and the child row only be deleted when the last referencing parent row…
Dennis
  • 2,607
  • 3
  • 21
  • 28
3
votes
2 answers

Delete second-to-last line of file using sed

I have a file.txt and I have to delete the second-to-last line of the file. The below three sed commands are able to print the second-to-last line. But I need to delete that line. Any help?? sed -e '$!{h;d;}' -e x file.txt sed -n 'x;$p'…
Arun
  • 105
  • 2
  • 5
3
votes
1 answer

Android: Attempt to read from field 'android.widget.TextView on a null object reference

i am trying to create a delete function to my listview but there is some problem that i cant locate and even i found the problem in the logcat i don't know where is the problem because the problem is pointer at a line that running ok in other…
gunZ333
  • 61
  • 1
  • 1
  • 10
3
votes
1 answer

Hibernate deleting all rows before inserting

I have this entity class, the first one I built to test Hibernate, it uses an oracle sequence to fill the ID field : @Entity @Table(name="COMPANIES") public class Companies { private Integer cmpid; private String…
guigui42
  • 2,441
  • 8
  • 35
  • 48
3
votes
1 answer

How to delete record from MySQL database using PHP and AngularJS?

I am working on a blog project and I am using PHP to grab data from a MySQL database and saving it into a JSON file and then outputting the data with AngularJS. I know this might not be the most efficient thing to do but angular has some advantages.…
sidlack
  • 51
  • 5
3
votes
1 answer

Excel automation C#: How to delete multiple rows?

I have the following code and it does not delete the rows, it asks me to save over the current workbook but nothing is saved and EXCEL.EXE continues to run in Task Manager: protected void OpenExcelWorkbook(string fileName) { _app = new…
user195488
3
votes
1 answer

Delete specific row in database table and generatet html table

This is my delete page : prepare($query); $pdoExec =…
Andry Jhonas
  • 379
  • 2
  • 13
3
votes
2 answers

How to delete row datagrid and update SQL database C#

I am really stuck and non of the books or tread here are user-friendly enough to explain how to delete data from data grid object using C# from varies of books and fourm threads I have managed to get this coded but it fails to executes the sql…
Waheed Rafiq
  • 460
  • 1
  • 6
  • 17
3
votes
1 answer

Delete option for ListView items always deletes first item irrespective of which item is clicked

I'm a newbie and I've been trying to develop a contacts application along with another to-do app, but this is a question related to my contacts app. The inserting and Viewing and Deletion functions work properly but the only problem is that no…
Android Self-learner
  • 45
  • 5
1 2 3
…
99 100