The syntax for SQL UPDATE

To utilize the UPDATE technique, first, determine which table needs to be updated by using UPDATE table_name. Then, using the SET statement, you specify what kind of change you wish to apply to the record. Finally, you use a WHERE clause to specify which entries should be modified.