35

When you UPDATE without WHERE.

Comments
  • 3
    At least it's not delete
  • 1
    That realisation is enough to bring the strongest of devs to tears 😭
  • 0
    Never autocommit. Use rollback.
  • 1
    After doing this once, I learned to always add a placeholder of "Where 1=0" before I begin writing any Update script.
  • 0
    This is why I avoid writing any dB operations on a live db. Too much fear.
Add Comment