Can the UPDATE query be used without a WHERE clause? And if so in what conditions?
UPDATE
WHERE
if you don't use the WHERE clause all the records on the table will be affected