Databases Reference
In-Depth Information
Another button is available on the navigation bar, but must be activated by setting
$cfg['ShowAll']
to
TRUE
. It would be very tempting for users to use this button
often. Hence, on a multi-user installation of phpMyAdmin, it is recommended
that the button be left to its default value of disabled (
FALSE
). When enabled,
the navigation bar is augmented with a
Show
all
button. Clicking on this button
retrieves all the rows of the current results set, which might hit the execution time
limit in PHP or a memory limit in the server; most browsers would also crash when
asked to display thousands of rows. The exact number of rows that can be safely
displayed cannot be predicted as it depends on the actual data present in columns
and on the browser's capabilities.
If we enter a big number in the
Show
__
rows
dialog, the same
results will be achieved (and we may face the same problems).
Query results operations
A section labeled
Query
results
operations
is located under the results. It contains
links to print the results (with or without the
FULL
TEXT
columns), to export these
results (refer to
Exporting
partial
query
results
section in
Chapter
6
), or to create a view
from this query (more on this in
Chapter 17
).
Displaying data as a chart
Another operation available is
Display
chart
. To practice this, we will use a different
query that selects only two columns. For this we can use the
Inline
link shown next
to the query and change the query to:
SELECT page_count, author_id from topic
Clicking on
Go
produces a result set with only those two columns; next we click on
Display
chart
, which generates the following panel:
Search WWH ::
Custom Search