DEV Community

Discussion on: Those silly mistakes we all make

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.