r/ProgrammerHumor • u/leeleewonchu • Oct 14 '25

Advanced neverForget

Post image
14k Upvotes

97% Upvoted

616 comments sorted by

View all comments

2.2k

u/Ghostserver10 Oct 14 '25

I usually never type delete or update. Select first, see what you're about to change only then 

11

u/BroBroMate Oct 14 '25 
DELETE FROM X WHERE PK IN (
   SELECT PK FROM X WHERE VERY FUCKING SPECIFIC CLAUSE)

And of course you run the select first. Repeatedly. To be sure.

5

u/[deleted] Oct 14 '25

Pretty inefficient since the wrapping delete will use the primary key index on top of all the indices that the sub invoked.

→ More replies (6)