It would be very tempting for users to use this button
often, so on a multi-user installation of phpMyAdmin, it is recommended that it be
disabled (FALSE). When enabled, the navigation bar is augmented as shown:
Clicking on the Show all 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 or browser.
If we enter a big number in the Show...rows dialog, the same results will
be achieved (and we may face the same potential problems).
Query Results Operations
A section labelled Query results operations is located under the results. It contains
links to print the results (without or with the FULL TEXT columns), to export these
results (see Chapter 7, section Exporting Partial Query Results) or to create a view from
this query (more on this in Chapter 18, MySQL 5.0 Features).
First Steps
[ 80 ]
Sorting Results
In SQL, we can never be sure of the order in which the data is retrieved, unless we
explicitly sort the data. Some implementations of the retrieving engine may show
results in the same order as when data was entered, or by primary key, but a sure
way to get results in the order we want is by sorting them explicitly.
When browsing results are displayed, any column header can be clicked to sort
on this column, even if it is not part of an index.
Pages:
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99