Inspectopedia
 
2024.3

Unsafe 'join' clause in 'delete' statement

Warning
New
Last modified: 03 December 2024

Reports missing conditional checks for statements that might modify the whole database.

For example, usages of JOIN clauses inside DELETE statements without ON or WHERE. Without conditional checks on JOIN, DELETE drops contents of the entire table.

Example (MySQL):