SQL UPDATE Statement

The UPDATE statement is used to update record in a table


SQL UPDATED Syntax
UPDATE table_name
SET column1 = value1, column2 = value2,.....
WHERE some_column = some_value


*we need to be more careful when updating records. If we had omitted the WHERE clause in the example above, then the change will be applied to all the records regardless of a specific record that needs to be changed.