265
you are viewing a single comment's thread
view the rest of the comments
[-] TheSlad@sh.itjust.works 17 points 1 year ago

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.

[-] GBU_28@lemm.ee 6 points 1 year ago

Good idea.

Easy enough to slap a where 1=1; on there if you want to burn the place down

this post was submitted on 16 Nov 2023
265 points (97.5% liked)

Very Real Tech Pics

1257 readers
1 users here now

There's no place like 127.0.0.1

founded 1 year ago
MODERATORS