Bug #53739 cannot edit table data with no primary key
Submitted: 18 May 2010 9:54 Modified: 19 Jun 2010 4:14
Reporter: Hari Prasad Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: Edit, primarykey, table data

[18 May 2010 9:54] Hari Prasad 
Description:
In the SQL Editor, in the Edit Table Data, cannot edit or insert row if the table does not have any primary key

How to repeat:
1. Create a table withot a primary key
2. goto SQL Editor -> Object Browser
3. right click on the table created and select "Edit Table Data"
4. Edit windows appears.
5. The Edit does not have any insert or edit option.
[19 May 2010 4:14] Valeriy Kravchuk 
There is no good way to generate correct UPDATE and DELETE statements for changes in a table without primary key defined. 

As for allowing INSERTs, this is possible and I'd call this a feature request. Do you agree?

IMHO tables without primary keys should never be used, and Workbench just gives you a "hint" of kind...
[19 Jun 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".