The SQL UPDATE Statement
The SQL UPDATE Statement
The UPDATE statement is used to update existing records in a table.Syntax
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
Note
Notice the WHERE clause in the SQL UPDATE statement! The WHERE clause specifies which record or records that should be updated. If you omit the WHERE clause, all records will be updated!Read more: The SQL UPDATE Statement
Login in to like
Login in to comment