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, 1474🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...