judico
asked on
Edit Contents of a Field in an MySQL Table in the cPanel of GoDaddy
Working with MySQL database used to be quite straightforward in the standard GoDaddy MySQL. Now GoDaddy has changed it (moved to new servers, they say) and editing the contents of the individual cells in a table of a database doesn't seem obvious. Does anyone know how to change said contents? It seems they explain everything else, which is mostly obvious, but not this particular very necessary editing: https://documentation.cpanel.net/display/1144Docs/MySQL+Databases
Dave Baldwin
That page says that phpMyAdmin is still available if that is what you are used to.
ASKER
All that still exists, save the option to edit fields. Probably an additional config.inc.php is to be created to allow such editing. This is what I'm getting from: http://docs.phpmyadmin.net/en/latest/index.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is some common problem. Some suggest to change one of the columns to primary: http://stackoverflow.com/questions/18922503/resolution-this-table-does-not-contain-a-unique-column-grid-edit-checkbox-ed
ASKER
Somehow this did it. I can't figure out how exactly.
That's what the message says and it was a change in version 4 of phpMyAdmin.
ASKER
The problem I encountered turned out to be a common problem with some seemingly counter intuitive solution. Thanks for the time spent to dwell into this problem together with me.
You're welcome, glad to help.