re: Those silly mistakes we all make VIEW POST

TOP OF THREAD FULL DISCUSSION
re: On prod env: drop table <important_table_here>; update <table> set <sequential_field> = <constant_val> :( now i check t...
 

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.

code of conduct - report abuse