Prev | Current Page 89 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

inc.php.
It may be interesting to visually mark some rows to highlight their importance for
personal comparison of data, or when showing data to people. Highlighting is done
by clicking the row. Clicking again removes the mark on the row. The chosen color is
defined by $cfg['BrowseMarkerColor'] (see themes/themename/layout.inc.
php). This feature must be enabled by setting $cfg['BrowseMarkerEnable'] to
TRUE, this time in config.inc.php??”this sets the feature for all themes. We can mark
more than one row. Marking the row also activates the checkbox for this row:
Limiting the Length of Each Column
In the previous examples, we always saw the full contents of each column, because
their number of characters was within the limit defined by $cfg['LimitChars'].
This is a limit enforced on all non-numeric fields. If this limit was lower (say 10), the
display would be as follows:
This would help us see more columns at the same time (at the expense of seeing less
of each column).
First Steps
[ 82 ]
To reveal the full texts, we can click the T besides the column header, which toggles
between the full-text mode and the partial-text mode:
Browsing Distinct Values
There is a quick way to display all distinct values and the number of occurrences
for each value for each field. This feature is available on the Structure page.


Pages:
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101