MySQL Forums
Forum List  »  MySQL Workbench

Re: safe update mode
Posted by: Aren Cambre
Date: September 13, 2010 05:13PM

Keith Bernard Wrote:
-------------------------------------------------------
> Hi Miftah
>
> I went to Edit->Predferences-->SQL Editor (Third
> tab) and unchecked the
> 'Forbid UPDATE and DELETE statements without a
> WHERE clause (safe updates)
>
> As I say I did need to restart SQL Workbench as
> well
>
> HTH


If that's really the text in MySql Workbench, it's incorrect. The problem is apparently where the WHERE clause doesn't contain a key, not simply that it's missing the WHERE clause.

Options: ReplyQuote


Subject
Views
Written By
Posted
36190
August 11, 2010 10:17AM
12027
August 11, 2010 11:21AM
7597
September 14, 2010 07:23PM
8085
August 12, 2010 01:40AM
6700
August 12, 2010 07:16AM
5789
August 18, 2010 07:37AM
5694
August 23, 2010 06:39AM
2940
August 24, 2010 10:52AM
2355
September 13, 2010 09:51PM
2411
September 14, 2010 06:25AM
3570
September 23, 2010 10:00AM
Re: safe update mode
2501
September 13, 2010 05:13PM
2687
August 30, 2010 02:46PM
3049
November 05, 2010 03:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.