this post was submitted on 16 Nov 2023
1 points (100.0% liked)
Very Real Tech Pics
1286 readers
1 users here now
There's no place like 127.0.0.1
founded 11 months ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Where clauses should be syntactically required for delete or update statements. Throw an error without them. If you really want to hit every record in the table then throw a WHERE true in there just to be explicit.
Its such a common mistake i dont get why this isnt a thing.
Good idea.
Easy enough to slap a where 1=1; on there if you want to burn the place down