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, 1138👍, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple t...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...