[TriLUG] MySQL needs an "undo" button

[Brian via TriLUG]

On 12/3/2015 11:38 PM, Wes Garrison via TriLUG wrote:
> 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

I feel your pain.  Once I accidentally omitted the WHERE clause entirely 
in a DELETE FROM statement.  Fortunately in that case, the data wasn't 
in production and was essentially a transformed version of a set of data 
in another database, so recovery was only painful, not impossible!

-B