Inspectopedia
 
2024.3

Delete or update statement without where clauses

Warning
New
Last modified: 03 December 2024

Reports usages of DELETE or UPDATE statements without WHERE clauses.

Without WHERE clauses, DELETE drops all the data from the table, and UPDATE overwrites values for all the table rows.

Example (MySQL):