Collections:
Deleting Existing Rows in MySQL
How To Delete Existing Rows in a Table in MySQL?
✍: FYIcenter.com
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.
⇒ Quoting Text Values in MySQL
⇐ Updating Existing Rows in MySQL
2017-06-28, 1398🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...