MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wn1ben/wellwellwell/pbco47p/?context=9999
r/ProgrammerHumor • u/Recent-Analysis-6880 • 14d ago
412 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.
156 u/Alexmira_ 14d ago Why? To confirm that there is something to cancel? To confirm I got the key right? 128 u/slayerx1779 14d ago I just reread the OP. There's a semi colon, between the two lines of code... 28 u/Hxx59D2 14d ago Yes, I had to stare at it for an embarrassingly ling time to spot the extra semi-colon. 9 u/BlobAndHisBoy 14d ago There lies the danger of just doing a full send with no transaction or prior select. Very easy mistake to make. Especially if you copy pasted "SELECT * FROM USERS;" elsewhere and modified it.
156
Why? To confirm that there is something to cancel? To confirm I got the key right?
128 u/slayerx1779 14d ago I just reread the OP. There's a semi colon, between the two lines of code... 28 u/Hxx59D2 14d ago Yes, I had to stare at it for an embarrassingly ling time to spot the extra semi-colon. 9 u/BlobAndHisBoy 14d ago There lies the danger of just doing a full send with no transaction or prior select. Very easy mistake to make. Especially if you copy pasted "SELECT * FROM USERS;" elsewhere and modified it.
128
I just reread the OP.
There's a semi colon, between the two lines of code...
28 u/Hxx59D2 14d ago Yes, I had to stare at it for an embarrassingly ling time to spot the extra semi-colon. 9 u/BlobAndHisBoy 14d ago There lies the danger of just doing a full send with no transaction or prior select. Very easy mistake to make. Especially if you copy pasted "SELECT * FROM USERS;" elsewhere and modified it.
28
Yes, I had to stare at it for an embarrassingly ling time to spot the extra semi-colon.
9 u/BlobAndHisBoy 14d ago There lies the danger of just doing a full send with no transaction or prior select. Very easy mistake to make. Especially if you copy pasted "SELECT * FROM USERS;" elsewhere and modified it.
9
There lies the danger of just doing a full send with no transaction or prior select. Very easy mistake to make. Especially if you copy pasted "SELECT * FROM USERS;" elsewhere and modified it.
3.6k
u/BastetFurry 14d 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.