You are viewing a single thread.
View all comments
85 points

I always run my queries in a script that will automatically rollback if the number of rows changed isn’t one. If I have to change multiple rows I should probably ask myself what am I doing.

permalink
report
reply
84 points

Damn that’s a good idea. Going to write that down, put it in the to do list, and regret not dosing it.

permalink
report
parent
reply
36 points
*

I always start a session with disabling auto commit (note, I could add it to my settings, but then it would backfire that one time my settings don’t execute, so I’m making it a habit to type it out every time, first thing I connect)

BTW: what kind of genius decides that auto commit should be enabled by default?

permalink
report
parent
reply
10 points

That’s a good idea too. I’ll have to look into that.

permalink
report
parent
reply
1 point
*

Or at least run it in the test database first.

Or run your updates/deletes as select first.

permalink
report
parent
reply

Programmer Humor

!programmerhumor@lemmy.ml

Create post

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

  • Posts must be relevant to programming, programmers, or computer science.
  • No NSFW content.
  • Jokes must be in good taste. No hate speech, bigotry, etc.

Community stats

  • 5K

    Monthly active users

  • 1.6K

    Posts

  • 35K

    Comments