mysql> undo;
 

Post here if you've ever found yourself wishing for this feature :(

hehe

before you do anything crazy always mysqldump :)

i learned that the hard way

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...

:mad:

LOL :1orglaugh :1orglaugh Check your queries before pressing enter! :glugglug

Ouch...

ouch... good thing you had a backup though.. :-/

i needed that one time when I put & instead of && in a delete and nuked a whole db

yeah transactions/rollback and stored procedures would be welcomed additions to mysql... still if u typo and execute the sql you're shit out of luck

I think my right pinky finger is faster than any other...

My brain thinks "that's not right" but my hand has already executed it.

That's great, this is gonna be a mysql horror story thread. I've done the same thing before! It sucks to nuke the whole database.

jDoG

Definately took the words out of my mouth :P

definately :(

transactions/rollback is supported for innoDB type tables if i'm not mistaken