The UPDATE statement is used to modify data in a table.
The UPDATE statement is used to update existing records in a table.
To learn more about SQL, please visit our SQL tutorial.
To get PHP to execute the statement above we must use the mysqli_query() function. This function is used to send a query or command to a MySQL connection.
Earlier in the tutorial we created a table named "Persons". Here is how it looks:
The following example updates some data in the "Persons" table:
After the update, the "Persons" table will look like this:
Your message has been sent to W3Schools.