Anyone know how to do this on DH?
When you click “browse” it defaults to 30 rows. At the top of the rows, you can change the number of results to display.
Or you can click SQL at the top and do something like this…
SELECT * from <TABLE_NAME> LIMIT 100
…and that will return 100 rows.
I know, but is there any way to make it show 100 rows by default when I hit browse?
Yes and no.
- Install PHPMyAdmin yourself
- After it is up and running, edit config.inc.php
- Add the following two lines.
$cfg['ShowAll'] = FALSE; // allows to display all the rows $cfg['MaxRows'] = 100; // maximum number of rows to display