4 ms·
I lived in constant fear of forgetting a WHERE clause. For those in constant fear: http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html#safe-updates http://d
by rimantas 16y ago
I lived in constant fear of forgetting a WHERE clause.
For those in constant fear: http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html#safe-updates http://dev.mysql.com/doc/refman/5.1/en/mysql-tips.html#safe-...
- idlewords 16y agoHa, I half-remembered this existing and tried to Google my way to it, but to no avail. Thanks so much for the pointer!
- deleted 16y ago[deleted]
- jtbigwoo 16y agoIn a huge database, even a SELECT with no WHERE clause can tie up considerable resources.
- dools 16y agoI always write my WHERE clauses first whenever I do anything on a live dataset.
- shii 16y agoIt's funny because I bookmarked this on pinboard.in
- SupremumLimit 16y agoI always had a rule to do everything inside a transaction. Having to commit a transaction gives you just enough pause to double check what you've done.