On prod env:
drop table <important_table_here>;
update <table> set <sequential_field> = <constant_val>
:( now i check ten times before run a command :(
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.
Sounds like a good time to test your DB backups too!
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.