MySQL UPDATE Statement

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:

Sample Table:

Example 1: UPDATE Statement Used on the age column.

Example 2: UPDATE Statement Used on the name column.