Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For some odd reason out of the blue my database in MySql will not allow me to manually edit any records. My guess is it never has. I am logged in with the Workbench under the root account. I have confirmed that the root matches any host as well as any schema.

I can edit other tables in the same database just fine. It is only 1 specific table that I am having trouble editing. Even if I write a query to run against the table it just says Executing forever and does nothing.

Any clues on this?

share|improve this question
up vote 2 down vote accepted

Found the problem. It was related to the fact that my table didn't have a Primary Key specified.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .