Deleting Existing Rows in MySQL
Q
How To Delete Existing Rows in a Table in MySQL?
✍: FYIcenter.com
A
If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row:
<?php
include "mysql_connection.php";
$sql = "DELETE FROM fyi_links WHERE id = 1102";
if (mysql_query($sql, $con)) {
print(mysql_affected_rows() . " rows deleted.\n");
} else {
print("SQL statement failed.\n");
}
mysql_close($con);
?>
If you run this script, you will get something like this:
1 rows deleted.
2017-06-28, 306👍, 0💬