12th March 14:49
delete from x where Id-122
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.
From: Januski, Ken [mailto:email@example.com]
Sent: Friday, March 28, 2003 1:45 PM
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
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32