b10hazard b10hazard - 11 months ago 66
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 Source

I found this on internet:

try this launch the workbench using:

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

it's a bug, take a look here:


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

MYSQL and python error