DEV Community

Discussion on: Those silly mistakes we all make

Collapse
undeveloper profile image
unDeveloper

On prod env:

  • drop table <important_table_here>;
  • update <table> set <sequential_field> = <constant_val>

:( now i check ten times before run a command :(

Collapse
philnash profile image
Phil Nash Author

Sounds like a good time to test your DB backups too!

Collapse
akashdeepsingh profile image
Akashdeep Singh

Oh yeah, this happened to me once. Ran an update without a where clause, and in the moments after that, I had planned my exile to a remote village in Scotland.
Fortunately, I had run select before the update, and it was a small table so al the data was on the terminal.

SET AUTOCOMMIT=0; after that.