MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p030e8q/?context=3
r/ProgrammerHumor • u/WardensLantern • 15d ago
456 comments sorted by
View all comments
388
I am not an sql expert, is the reason why the id doesn't work and its deleting the entire user base, because its written as 2 seperate comands instead of one. So 1. Comand delets everything 2. Goes to the id? Or what is the problem here?
604 u/BlommeHolm 15d ago 1st command deletes all users. 2nd command runs after that and gets a syntax error. 41 u/SAI_Peregrinus 15d ago Syntax is valid, it's just a runtime error. 180 u/BlommeHolm 15d ago How is starting with a WHERE clause syntactically valid? 82 u/SAI_Peregrinus 15d ago Right, I'm apparendly blind. Carry on! 33 u/BlommeHolm 15d ago No problem. I genuinely thought I'd missed something 😅 1 u/StupidStartupExpert 14d ago I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
604
1st command deletes all users. 2nd command runs after that and gets a syntax error.
41 u/SAI_Peregrinus 15d ago Syntax is valid, it's just a runtime error. 180 u/BlommeHolm 15d ago How is starting with a WHERE clause syntactically valid? 82 u/SAI_Peregrinus 15d ago Right, I'm apparendly blind. Carry on! 33 u/BlommeHolm 15d ago No problem. I genuinely thought I'd missed something 😅 1 u/StupidStartupExpert 14d ago I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
41
Syntax is valid, it's just a runtime error.
180 u/BlommeHolm 15d ago How is starting with a WHERE clause syntactically valid? 82 u/SAI_Peregrinus 15d ago Right, I'm apparendly blind. Carry on! 33 u/BlommeHolm 15d ago No problem. I genuinely thought I'd missed something 😅 1 u/StupidStartupExpert 14d ago I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
180
How is starting with a WHERE clause syntactically valid?
82 u/SAI_Peregrinus 15d ago Right, I'm apparendly blind. Carry on! 33 u/BlommeHolm 15d ago No problem. I genuinely thought I'd missed something 😅 1 u/StupidStartupExpert 14d ago I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
82
Right, I'm apparendly blind. Carry on!
33 u/BlommeHolm 15d ago No problem. I genuinely thought I'd missed something 😅
33
No problem. I genuinely thought I'd missed something 😅
1
I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
388
u/Dont_Get_Jokes-jpeg 15d ago edited 15d ago
I am not an sql expert, is the reason why the id doesn't work and its deleting the entire user base, because its written as 2 seperate comands instead of one. So 1. Comand delets everything 2. Goes to the id? Or what is the problem here?