mysql - Organizing a database using folders in phpMyAdmin -


right have database in phpmyadmin, , off the side of screen, shows database name, , list of tables inside database. it's fine if it's couple of tables, when there's dozens of tables, gets hard find tables want edit. i've thought creating database make easier organize, i'll have connect using different database's name , different user login database, , thought how easier if can make folders or similar inside database have organize tables. i'm wondering if possible, or know work-around issue.

well, can't create database (or folders) within database; that's not mysql able do.

phpmyadmin has grouping feature may situation. default, databases prefix followed _ (a single underscore) grouped together, tables __ (two underscores).

here's example of how ends looking when grouped:

database:

enter image description here

table:

enter image description here

if you're able rename of tables, you'll able take advantage of grouping feature make phpmyadmin display bit more manageable. of course, won't change way other tools display table list.

the configuration directives $cfg['navigationtreedbseparator'] , $cfg['navigationtreetableseparator'] control separator used. relevant documentation starts @ http://docs.phpmyadmin.net/en/latest/config.html#cfg_navigationtreeenablegrouping , includes next few line items.


Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more