kjanuski

------_=_NextPart_001_01C36111.C12DD310
Content-Type: text/plain;
charset="iso-8859-1"

I DID IT AGAIN!!! I thought rm * was bad in Unix but this little slip of the
finger replacing a = with a - is just as bad in mySQL. Fortunately I did
have a recent mysqldump dump. Unfortunately I didn't follow my own advice to
always run mysqldump before deleting anything.

-----Original Message-----
From: Januski, Ken [mailto:kjanuski@phillynews.com]
Sent: Friday, March 28, 2003 1:45 PM
To: win32@lists.mysql.com
Subject: delete from x where Id-122


I'm stuck with my accidental deletions and am only thankful that it wasn't
an important table. But I'm wondering if someone can explain what happened:

I was trying to delete the last entry of a table (Id=122). I meant to type
"delete from x where Id=122". Instead I typed "Id-122". As far as I can tell
everything (99% of table) got deleted. I believe entry for id=122 stayed.
I'm just curious as to the logic that caused everything to get deleted.

Thanks for any info

Ken

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=kjanuski@phillynews.com

------_=_NextPart_001_01C36111.C12DD310--