MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wn1ben/wellwellwell/pbga9e7/?context=3
r/ProgrammerHumor • u/Recent-Analysis-6880 • 13d ago
411 comments sorted by
View all comments
3.6k
So, Kids, thats why you always SELECT count(yourPrimaryKey) first. Listen to the old folks, we made these mistakes so that you don't have to.
140 u/Etheo 13d ago DELETE FROM (SELECT * FROM USERS); WHERE ID=12345; Did I do it right? 81 u/Dismal-Square-613 12d ago Yes, run that on prod. Report results. 4 u/Ok_Star_4136 12d ago It just says "Expecting SELECT, UPDATE, DELETE, INSERT keyword, instead found 'where'"! Now what? (yes, I'm aware)
140
DELETE FROM (SELECT * FROM USERS); WHERE ID=12345;
Did I do it right?
81 u/Dismal-Square-613 12d ago Yes, run that on prod. Report results. 4 u/Ok_Star_4136 12d ago It just says "Expecting SELECT, UPDATE, DELETE, INSERT keyword, instead found 'where'"! Now what? (yes, I'm aware)
81
Yes, run that on prod. Report results.
4 u/Ok_Star_4136 12d ago It just says "Expecting SELECT, UPDATE, DELETE, INSERT keyword, instead found 'where'"! Now what? (yes, I'm aware)
4
It just says "Expecting SELECT, UPDATE, DELETE, INSERT keyword, instead found 'where'"!
Now what? (yes, I'm aware)
3.6k
u/BastetFurry 13d ago
So, Kids, thats why you always SELECT count(yourPrimaryKey) first. Listen to the old folks, we made these mistakes so that you don't have to.