• @mikyopii
    link
    874 months ago

    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.

    • @[email protected]
      link
      fedilink
      844 months ago

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

    • @[email protected]
      link
      fedilink
      36
      edit-2
      4 months ago

      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?

      • @mikyopii
        link
        104 months ago

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

    • @[email protected]
      link
      fedilink
      1
      edit-2
      3 months ago

      Or at least run it in the test database first.

      Or run your updates/deletes as select first.