Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Let's say I have table in database. I'd like to be able to view all data from this table and be able to edit every field from single screen. I tried to do this in phpmyadmin but I'm not sure how... I can see all data but I have to click edit on single field and then I'm sent to next screen, can't really edit everything at once.

How do I do this in phpmyadmin or other mysql gui? I'm on Linux, my server too.

I'd like each field in table to be editable text field - maybe this will show better what I'm searching for.

share|improve this question
up vote 0 down vote accepted

Does it have to be web based? If not, you could always use the MySQL GUI Tools as provided by MySQL. There are downloads for Windows, Mac and Linux platforms.

The one you'll want to use is MySQL Query Browser. The other tools, like MySQL Administrator, are useful for backing up and creating table relationships visually.

share|improve this answer
No, it doesn't have to be web based. Will this one let me edit like this? How do I do it, any tutorials? – lorem Oct 26 '10 at 16:34
Um... have you ever used a spreadsheet program, like Excel? It's very similar to that. Very, very easy to learn. You can edit multiple fields and then apply the update all at once. – Corey Oct 26 '10 at 16:35
Like spreadsheet? Ah, so I can just click and it will edit? It might be it, I'll try it. – lorem Oct 26 '10 at 16:38
@lorem I've included a screenshot and a little more information. Hope it helps! – Corey Oct 26 '10 at 16:45

Maybe emma is worth a try. I found it quite useful and easy to use.

share|improve this answer
Yeah I'd like to edit all these fields at the same time not click on each one and get pop-up window xP (as I assume emma works after looking at screenshots) – lorem Oct 26 '10 at 16:27
If you mean this screenshot, well that's the editing of the structure of a table and not its content. As far as I remember it's possible to edit the fields just like a spreadsheet. Take a try if you want. – cYrus Oct 26 '10 at 16:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .