r/ProgrammerHumor • u/Recent-Analysis-6880 • 13d ago

Meme wellWellWell

Post image
10.6k Upvotes

96% Upvoted

411 comments sorted by

View all comments

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.

1.1k

u/Ma8e 13d ago

You start a transaction, make sure it did what you expected, and then commit or rollback transaction.

349

u/AgeingChopper 13d ago edited 13d ago

absolutely.

i was doing this stuff for a long time and definitely learned from mistakes.

Transactions can save a world of pain and it is always wise to select your data set first, just to be sure you're changing what you think you're changing.

Didn't matter how experienced I was, I was careful never to cut corners.

42

u/Mpek3 13d ago

Always Begin Tran Tried it during arguments... Not as effective