b10hazard b10hazard - 21 days ago 9
MySQL Question

table not editable mysql workbench error

I have a table that has no primary key. All I want to do is see the data. I DO NOT WANT TO EDIT IT. Yet, whenever I run this query...

SELECT * FROM TableThatHasNoPrimaryKey


MySQL Workbench (version 5.2.36 v8542, running on Ubuntu 10.04 64 bit) gives me this error...

table data is not editable because there is no primary key defined for the table


Is this a bug? This query displays the data just fine on MySQL browser.

Answer

I found this on internet:

try this launch the workbench using:

"mysql-workbench --log-level=debug3"

it's a bug, take a look here:

http://bugs.mysql.com/bug.php?id=62893

if not you will have to add a primary key, take a look to this forum

MYSQL and python error