Solved

Selecting a table directly in phpMyAdmin

Posted on 2016-08-28
4
43 Views
Last Modified: 2016-08-28
After opening a database with phpMyAdmin all the tables in the database are displayed in the right pane:
 
phpMyAdmin tables
For something like multisite WordPress (above) there could be 250 tables. I'm often interested in the wp_users table, which is a couple of hundred down, but I haven't found a way to open it directly, so I'm always scrolling all the way down and then selecting it.  Is there a way to open a specific table directly in phpMyAdmin?

Thanks
0
Comment
Question by:steva
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
Mukesh Yadav earned 500 total points
ID: 41773896
You can add that table to favorite list. Just locate the table and click on the star icon to add this to favorite list. And next time just go to favorites list left top "Favorites"
0
 

Author Closing Comment

by:steva
ID: 41773971
Perfect!  Thank you.
0
 

Author Comment

by:steva
ID: 41774329
Actually, this isn't working as well as I thought.  After clicking the star for the table, the table is available under Favorites as long as I stay c onnected to phpMyAdmin.  But if I shut down phpMyADmin and then open it up again, no favorites are set.
0
 
LVL 6

Expert Comment

by:Mukesh Yadav
ID: 41774336
No phpMyAdmin saves this data in DB so there is no chance of loosing this Favorite list when you log in again.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now