CODEWITHSUNDEEP
mysqlubuntumysql-workbench
Iacchus
Iacchus

Reputation: 2837

MySQL Workbench 6.1 - No option to insert rows?

Version 5.2 of MySQL Workbench has an option to add rows to a table graphically, right clicking the table name from the list of tables. This option is really lacking in MySQL Workbench 6.1 or is it hidden?

On an Ubuntu 13.10.

MySQL Workbench 6.1

no 'null' row to insert no 'Edit Table Data' option

Upvotes: 5

Views: 9086

Answers (3)

Iacchus
Iacchus

Reputation: 2837

The version in the the Ubuntu 14.04 repositories seems to be working and is the new version of the program.

Upvotes: 0

Iacchus
Iacchus

Reputation: 2837

It should be a bug. It says that the Table is read only, because it don't have a primary key, but the table has it.

Table has readonly flag and it's tooltip says that "The table has no unique row identifier (primary key or a NOT NULL unique index)" readonly flag

But table has primary key: enter image description here

This is version 5.2.47... i uninstalled the new, because I think it is a bug. enter image description here

Upvotes: 2

Matt K
Matt K

Reputation: 6709

I'm usually looking at the contents of a table before I add a row to it, and there's always an empty row at the bottom of the result set (the whole row is nullified) which you can click on and add content to. Then just hit "Apply".

Upvotes: 4

Related Questions