[TriLUG] MySQL needs an "undo" button

[William Sutton via TriLUG]

Not Linux related, but word of caution:  SQL Server Management Studio has 
autocommit enabled by default.  If you find yourself having to use it, 
disable autocommit first.  (I got bit by that once).

William Sutton

On Fri, 4 Dec 2015, Brian via TriLUG wrote:

> 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
>
> -- 
> This message was sent to: William <william at trilug.org>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that 
> address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web	: 
> http://www.trilug.org/mailman/options/trilug/william%40trilug.org
> Welcome to TriLUG: http://trilug.org/welcome