this post was submitted on 16 Nov 2023
242 points (97.6% liked)

Very Real Tech Pics

1368 readers
1 users here now

There's no place like 127.0.0.1

founded 2 years ago
MODERATORS
Synthead@lemmy.world
242
The exact moment Jared realized that he forgot the WHERE clause in his DELETE FROM query (infosec.pub)
submitted 2 years ago by Synthead@lemmy.world to c/veryrealtechpics@lemmy.world
20 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[โ€“] TheSlad@sh.itjust.works 1 points 2 years ago (1 children)

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 1 points 2 years ago

Good idea.

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