phpMyAdmin在MySQL视图中缺少分页按钮 [英] phpMyAdmin is missing pagination button in MySQL views

问题描述

显示视图时，我的phpMyAdmin缺少分页按钮.我的视图大约有20.000行.

My phpMyAdmin is missing pagination buttons when showing a view. My view have about 20.000 rows.

如何在视图上启用分页按钮?

How I can enable pagination buttons on views?

推荐答案

基本上，我必须为视图启用行计数，方法是在文件config.inc.php的底部添加此行(放置在phpMyAdmin安装目录中) :

Essentially I have to enable row counting for views, by adding this line at the botton of the file config.inc.php (placed in the phpMyAdmin install directory):

$cfg['MaxExactCountViews'] = 100000;

100000是您估计视图将包含的最大行数.该参数默认为零，这可能是因为行计数会影响性能. 是否可以通过phpmyadmin中的视图进行分页? /a>

100000 is the maximum number of rows that you estimate the view will contain. This parameter is defaulted to zero, probably because the row counting impacts on performance. Is it possible to page through a view in phpmyadmin?

在这里找到答案(答案一开始我还不清楚，但是我尝试了并且工作了):

Found the answer here (the answer was not clear to mein the first, but I tried and I worked): Is it possible to page through a view in phpmyadmin?

这篇关于phpMyAdmin在MySQL视图中缺少分页按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！