[TriLUG] MySQL needs an "undo" button

[Wes Garrison via TriLUG]

Oops:
update optionGroups set name="new name" *where id-30156;*
Query OK, 28829 rows affected (0.19 sec)
Rows matched: 28829  Changed: 28829  Warnings: 0

That should have said *where id=30156*;

Guess what the highest id was?

Yep, 30156.

Always backup first!

-Wes
_________________________________
Wesley S. Garrison
Network Engineer
Xitech Communications, Inc.
phone:  (919) 260-0803
pager:   (919) 869-1744
fax:       (919) 932-5051
__________________________________
"Lead us not into temptation, but deliver us from email."