Jump to content
  • 0

[Solved] Mysql Workbench Read Only Table


Deimler

Question


  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  58
  • Reputation:   0
  • Joined:  09/23/12
  • Last Seen:  

Hi

I am having a bit of an issue with mysql workbench
I am connected to mysql with workbench from my local computer but I am unable to change some information because it is a "read only" table. 
Quote: "Table mob_skill_db has no primary keys or unique non nullable columns defined..."

It continues on saying that only primary keys or unique non null-able columns can be edited.
Do you guys by any chance know of a solution to this? 
I've been searching online but I am unable to find the answer.

Thank You.



Bump
 

Edit: I was looking at some other .sql and I noticed that they had      " PRIMARY KEY  (`....`) "
I just added the script in the original file and it was editable~!

Edited by Deimler
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...