php - phpMyAdmin: change default number of rows displayed?

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

589 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T17:47:39+0000

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.