Resources‎ > ‎SQL‎ > ‎DML Statements‎ > ‎

UPDATE Statements

The update statement is used to change values that are already in a table

The update expression can be a constant, any computed value, or even the result of a SELECT statement that returns a single row and a single column. If the WHERE clause is omitted, then the specified attribute is set to the same value in every row of the table (which is usually not what you want to do). You can also set multiple attribute values at the same time with a comma-delimited list of attribute=expression pairs.

This will show the different types of update statements and how the different database vendors handles them.