To use the UPDATE method, you first determine which table you need to update with UPDATE table_name . After that, you write what kind of change you want to make to the record with the SET statement. Finally, you use a WHERE clause to select which records to change

UPDATE Syntax:
UPDATE table_name
SET column1 = value1, column2 = value2, …
WHERE condition;

• The UPDATE statement is used to modify the existing records in a table.

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.