PhpStorm
 
2022.2
Get PhpStorm
You are viewing the documentation for an earlier version of PhpStorm.

Code Inspection: Delete or update statement without where clauses

Last modified: 13 May 2022

Configure inspections: Settings / Preferences | Editor | Inspections

Show intention actions: Alt+Enter

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):