phpMyAdmin: change default number of rows displayed?

Using phpMyAdmin version 3.4 and above you are able to change the default rows shown by:

On the phpMyAdmin home screen click Settings >> Main frame >> Browse mode and altering the value within Maximum number of rows to display.

In your phpMyAdmin directory, there will be a file called "config.inc.php".

Find the line where it sets the MaxRows value:

$cfg['MaxRows'] = 1000;

And change the value to whatever you want.

I have no access to config.inc.php

To show more records I add to my query:

LIMIT 0,1000;

to show 1,000 records, from 0 to 1000.

You can change 1000 to any number according to your needs.

One example:

SELECT id, folio, sucursal
FROM equipos
WHERE sucursal = 3
ORDER BY folio
LIMIT 0,1000;

Greetings from Mexico!

Already Checked..... Simple Steps Follow:-

Go PhpAdmin
Select Your Table
In Your table there is a field name Show, Which is actually a Button. Here two boxes present like(Start row(0) Number of Rows(1000) Header every(100)). ----
Press on Show button.

Related