Collections:
Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL?
✍: FYIcenter.com
Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values:
<?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8" . " WHERE id = 102"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows updated.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows updated.
⇒ Deleting Existing Rows in MySQL
⇐ Breaking Query Output into Pages in MySQL
2023-09-10, 1846🔥, 1💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...