mysql not editable

2 posts / 0 new
Last post
#1 Fri, 09/04/2009 - 16:42
bwade30

mysql not editable

When I go in to edit my tables in webmin for mysql I get this message:

Data in this table cannot be edited because it has no primary key.

How do I get this database to be editable in webmin? This is very important to figure out as this is not the first time I've encountered this issue.

Thanks

Sun, 09/06/2009 - 22:10
andreychek

Howdy,

Sounds like your table(s) don't have a primary key set.

That can cause problems, as it may not always be possible to accurately know which record to update when making changes to the table.

Rather than guess, Webmin appears to be requiring you create a primary key before moving forward.

You can add fields using Webmin, phpMyAdmin, or just from the command line.

-Eric

Topic locked