259
The exact moment Jared realized that he forgot the WHERE clause in his DELETE FROM query
(lemmy.world)
this post was submitted on 16 Nov 2023
259 points (97.4% liked)
Very Real Tech Pics
1287 readers
1 users here now
There's no place like 127.0.0.1
founded 1 year 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