I've got a database with several tables in MySQL. All of the tables are editable using workbench and HeidiSQL, except one. I used HeidiSQL to import a CSV file into a new table called spissues. When I select * from that table, the option to edit does not appear. Although all other tables the edit option is available. I've tried this directly on the server machine as root, remotely as a user that has most of the same permissions as root, and remotely as the regular user. They all have full permissions (the regular doesn't have Admin roles, but does have full Schema rights). Can anyone suggest something to look for?
It's very possible you have not defined a primary key on the table that doesn't have an edit user interface. HeidiSQL and Workbench both need a primary key to be able to replace rows in the table from their table-edit user interfaces.