Updating data in all rows
We have a
students table below. Let’s say we want to update
marks of all the students to
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.