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