Learn More
Resend Email
58
gurbakhshish
9y

The moment when you realize you just ran a SQL update with a ';' before the WHERE clause............fml

undefined

fubar

fml

sql
Favorite
Ranter
Comments
  • 3
    9y
    ...and you don't have a backup.
  • 4
    9y
    @PoweredByCoffee backup is for sissies
  • 5
    9y
    Hate when that happens. I created DDL in PL SQL that contained a create trigger statement and a series of drop sequence statements, and I forgot the / after the trigger. Everything worked exactly as written ... once.
  • 1
    9y
    My condolences
  • 0
    9y
    And its Friday evening
  • 9
    9y
    You don't work at AWS or Gitlab by chance, do you?
  • 1
    9y
    @sande that wasn't me
  • 1
    9y
    Or when you're hacking a script in a transaction but forget to deselect the update query before excetuting. Happened to me a couple days ago 😳
  • 2
    9y
    Update without a where is also a good way to get busy :/
  • 2
    9y
    uhm... transactions... anyone?
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment