CODEWITHSUNDEEP
mysqlphpmyadminweb-hosting
Obfuscated
Obfuscated

Reputation: 105

Editing values in PhpMyAdmin?

I've been trying to use PhpMyAdmin for a while, and after a lot went wrong, I finally got it working. However, I have one more question that isn't at the top of my list but would be nice to have solved. How do you edit a value of a column in PhpMyAdmin? Right now I have the fields 'username' and 'password'. I've added a value to them but now I can't find where to edit or remove that value.

Can anyone help me?

Thanks

Upvotes: 5

Views: 21366

Answers (2)

Jérémy
Jérémy

Reputation: 228

I found out the solution as I had the same problem. It's not about versions!
You need to have a column that is primary as it make it unique, otherwhise phpmyadmin would not let you edit from here.

That's why it doesn't work for you either, if you only have the fields 'username' and 'password' and no "id" or so, then no unique column and so can't fast edit.

Upvotes: 10

Marc Scheib
Marc Scheib

Reputation: 2009

It probably depends on your version. In my current version (4.4.14), it looks as follows:

enter image description here

After you selected your database & table on the left side, you need to Browse that table (marked yellow). Then you can edit or delete rows. It is even possible to double click a value in a cell to directly edit it (newer versions).

Upvotes: 1

Related Questions