MySQL Forums
Forum List  »  MySQL Workbench

Re: safe update mode
Posted by: Thomas Mobley
Date: September 23, 2010 10:00AM

I'm having this problem as well. but I'm udpating a column in my table using the primary key in the where clause:

update parents set settings = (settings + 524288) where rabbitID = '08dffb0b-7c4a-0004-8b88-d0b52a4f3924';

rabbitID is the sole primary key for the parents table. Further, that preference checkbox doesn't say "where the primary key is not in the where clause", it states that the preference is to not udpate/delete when there is NO where clause in order to prevent accidental updates to the entire table, which does make sense, however since I'm not only using a where clause but I'm using the primary key in the where clause to constrain the update this makes no sense at all and obviously is not only not doing what it says it will, it's doing something that it's not even supposed to do. After I unchecked the box and restarted it did allow me to update the row, so it appears that what that checkbox really does in this version is prevent ANY updates or deletes at all. I'm running under Ubuntu 10.04 64 bit with workbench 5.2.27.

As a separate issue, check for updates is disabled for some reason, possibly because this is the current version, but if that's the case it makes little sense to show the selection disabled, it would make more sense if it just said no updates available if you click it (or have the button itself say no updates available) rather than leave you wondering why you can't CHECK for updates. If there were updates why wouldn't it say so rather than say check for updates that it's already aware exist. This seems backwards.

Options: ReplyQuote


Subject
Views
Written By
Posted
36193
August 11, 2010 10:17AM
12027
August 11, 2010 11:21AM
7597
September 14, 2010 07:23PM
8086
August 12, 2010 01:40AM
6700
August 12, 2010 07:16AM
5789
August 18, 2010 07:37AM
5694
August 23, 2010 06:39AM
2941
August 24, 2010 10:52AM
2355
September 13, 2010 09:51PM
2411
September 14, 2010 06:25AM
Re: safe update mode
3571
September 23, 2010 10:00AM
2502
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.