Databases Reference
In-Depth Information
There is also a
Page number
drop-down menu, to go directly to one of the pages
located near the current page. Since there can be hundreds or thousands of pages, this
menu is kept small with only a few page numbers before and after the current page.
Selecting
vertical mode
on the
student-course
table generates the following screen:
By design, phpMyAdmin always tries to give quick results, and one way to achieve
this result is by adding a
LIMIT
clause in
SELECT
. If there is already a
LIMIT
clause
in the original query, phpMyAdmin will respect it. The default limit is 30 rows, set in
$cfg['MaxRows']
. With multiple users on the server, this helps keeping the server
load to a minimum.
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, 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.
Search WWH ::
Custom Search