Steve
Steve

Reputation: 1765

How to edit a table field value in PHPMyAdmin

In PHPMyAdmin, I am looking at a table, but I see no way to edit a table entry (not sure of the correct terminology sorry).

enter image description here

The value I want to edit is DisableAdminPWReset (to 0).

How do I do this? There are no methods of editing this value that I can see. I am a SQL newb too.

Upvotes: 1

Views: 10581

Answers (1)

Carlos Cartola
Carlos Cartola

Reputation: 11

I've experienced the same problem now. Following Dave's instructions on an answer above I was going to try to put an index on the table, but I've realized that normalized tables usually have a primary key configured. It was enough to enable editing table lines. I've just entered the table structure tab and clicked at my table primary key "primary" button/link to turn it formally into the primary key and the "problem" was solved.

Upvotes: 1

Related Questions