Menu
By default, phpMyAdmin shows me 30 rows whenever I load a table (the query contains "LIMIT 30"). I generally want to see (up to) a few hundred rows.
Is there a way to change that default setting?
903
So as the answer there can be 1,073,741,824 rows.
Click on the table you wish to modify. Inside the table, you will see a list of columns. To the right of the column name, you will see a link called "Change" under the Actions. Click on the Change link for the column you wish to modify.
CHAR = Characters – used to store character string value of fixed length, the maximum number is of characters is 255. VARCHAR = Variable Length Characters – used to store variable length alphanumeric data and can store up to 65,535 characters.
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.
91
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.
42
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!
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
