mysql> undo;

[fuzebox]

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

[tical]

hehe

before you do anything crazy always mysqldump

i learned that the hard way

[fuzebox]

Originally posted by tical
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...

[JSA Matt]

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

LOL Check your queries before pressing enter!

[NickPapageorgio]

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

[woj]

Originally posted by fuzebox

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

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

[s9ann0]

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

[bawdy]

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

[fuzebox]

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.

[JDog]

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

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

[jwerd]

Originally posted by NickPapageorgio
Ouch...

Definately took the words out of my mouth :P

[Illicit]

definately

[Lane]

Originally posted by bawdy
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

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