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";