MySQL Bugs: #9959: "Edit" button disabled in "Result Set" window when table has no primary key

Bug #9959	"Edit" button disabled in "Result Set" window when table has no primary key
Submitted:	17 Apr 2005 16:20	Modified:	5 Mar 2009 12:20
Reporter:	Naga Kiran k	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.2.12	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
"Edit" button on "Result Set" screen is being enabled only if table has primary key.

How to repeat:
Fire a simple select statment on a table which is not having primary key..
We can't edit the data of the rows returned by the above select as "Edit" button will be disabled.

I'm also noticing this same problem using version 1.1.15 (running on Windows XP SP2).

Still here with version 1.1.20

A prominent scheme where this bytes me (when trying to remove typos) is bugzilla's 'longdescs' table...

Please add this!

when I tried a work-around with opening a script tab and adding my script 

update longdescs  set thetext = 'moved to bug 1772\n\nOtherwise, ...\n>>' where bug_id = 1468 and bug_when = '2006-05-21 07:52:32';

I only got a misleading error "connection problem:  could not execute command" which is not true since a select still works ...

I got myself a script tab because the text had linefeeds and in the query window, it is awkward to try to fix this

Bug #19982

see also Bug #23105

Many thanks for writing a feature request.
Verified as described. Edit button is hidden when table has no PK.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/