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, 1732🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...