UPDATE Query without WHERE Clause

if you don't use the WHERE clause all the records on the table will be affected


The UPDATE statement in SQL is used to update records in the table. We can modify one or multiple records (rows) in a table using UPDATE statement. If you do not use WHERE clause in UPDATE statement, all the records in the table will be updated.


So, I think when you want to update the whole field for some kind of reasons like updating the status of users enrollment to free for all users.

UPDATE users SET status = "free";