sql-delete Archives

[Solved] Delete duplicate rows using certain conditions in MS SQL Server

April 14, 2023 by Kirat

Introduction [ad_1] When working with data in MS SQL Server, it is often necessary to delete duplicate rows based on certain conditions. This can be done using a combination of the SELECT DISTINCT and DELETE statements. The SELECT DISTINCT statement is used to return only unique rows from a table, while the DELETE statement is … Read more

[Solved] Delete record from table using Checkbox [duplicate]

January 14, 2023 by Kirat

[ad_1] Change your PHP code as below $del_id = $_POST[‘checkbox’]; $detectinglocations=”your database table name”; foreach($del_id as $value){ $sql = “DELETE FROM “.$detectinglocations.” WHERE id='”.$value.”‘”; $result = mysql_query($sql); } 2 [ad_2] solved Delete record from table using Checkbox [duplicate]