MySQL UPDATE Statement:
The primary statement used to modify the existing data in a MySQL database is an UPDATE statement. The UPDATE statement allows you to modify one or more fields for one or more records in a table. Here the basic syntax for the UPDATE statement is:
| UPDATE table_name SET field1 = new_value1, field2 = new_value2 [WHERE Clause] |
Sample Table:
Example 1: UPDATE Statement Used on the age column.
Example 2: UPDATE Statement Used on the name column.
Comments (No)