Skip to content

update-without-where-clause (GN022)#

Automatic fix is not available.

What it does#

Checks for UPDATE without a WHERE clause.

Why not?#

Executing an UPDATE line without a WHERE clause will update all the rows in the table which is most likely an accidental mistake and not what you want.

When should you?#

Never.

Use instead:#

Add necessary WHERE clause.