3 ms·
I've done an UPDATE without a WHERE on a large database before. Fortunately the table was so large that the UPDATE took a significant amount of time, and I was
by jstanley 9y ago
I've done an UPDATE without a WHERE on a large database before. Fortunately the table was so large that the UPDATE took a significant amount of time, and I was able to type ^C before it completed, which meant the result of the update never got committed and no damage was done!
- protomyth 9y agoIf the database you are using understands transactions then it is best to begin a transaction before any update to make sure you did it correctly.