SQL Updating All Rows

Download SQL for free

Example

This example uses the Cars Table from the Example Databases.

UPDATE Cars
SET Status = 'READY'

This statement will set the 'status' column of all rows of the 'Cars' table to "READY" because it does not have a WHERE clause to filter the set of rows.

Updating Specified Rows