Updating data in tables

Updating data in all rows

We have a students table below. Let’s say we want to update marks of all the students to 90.

We can use the UPDATE table statement to do this, without any filter.

Observe that if we skip the WHERE clause for an UPDATE statement, the update is applied over all the rows in the table.