Published 16 November 2017
UPDATE statement without WHERE or INNER JOIN clause
The UPDATE statement has neither a WHERE nor an INNER JOIN clause, and it will update every row in the table.
It is very easy to update an entire table when you mean to update just one or more rows. Update statements should also be in a transaction so you can check the result before committing.