Update

SQL UPDATE

The UPDATE command is used to modify records in an SQL table.
You can modify all records or only certain records in a database table.

Syntax

UPDATE table_name
SET
column1 = value1,
column2 = value2,
column3 = value3,

WHERE {condition}

Example

UPDATE students SET age = 20 WHERE student_id=1 AND name='Tom';