SQL - Update

The update clause updates column values of a table. Update requires a conditional statement to select the row to be updated.

UPDATE employees
SET Lastname = 'Fletcher', Firstname = 'Ron'
WHERE id = '11';

SQL Table:

Here we changed record 11, our manager, to a new manager.

SQL - Updating Multiple Rows

With the use of expressions and operators, update allows for the manipulation of several rows at once.

UPDATE employees
SET Title = UPPER(Title);

SQL Table:

Using the UPPER expression we changed our Title field to all capital letters. Update also supports the use of subqueries.

• Go Back
• Continue