Simple solution: BEGIN TRAN DELETE (without where clause) UUPS! ROLLBACK That sa... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

CaptainZapp on March 23, 2016 | parent | context | favorite | on: An administrator accidentally deleted the producti...

Simple solution:

  BEGIN TRAN
  DELETE (without where clause)
  UUPS!
  ROLLBACK

That said it would be not quite honest that there wasn't an incident in my past, which enforces this policy. Always! Without fail!

rlidwka on March 23, 2016 [–]

Better solution is:

    BEGIN TRAN; DELETE (without where clause)

... on the same line.

I've lost a lot of data to "oh lets find that line in mysql history... up, up, enter, FUCK"

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact