Thread: mysql> undo;
View Single Post
Old 05-25-2004, 05:22 PM  
NickPapageorgio
Confirmed User
 
Join Date: Apr 2004
Location: NC
Posts: 8,323
Quote:
Originally posted by fuzebox
Hehe yes... On my big production database I usually run a nightly mysqldump as well, has saved my ass before.

My big problem is with quick little queries, it's happened before, I always stick a semicolon before "WHERE".

Ie...

mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...

Ouch...
__________________
NickPapageorgio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote