如何在 PHPMyAdmin 中为表设置默认排序(即始终为“主键 - 降序")

2022-01-05 00:00:00 php mysql phpmyadmin

尽管它在很多方面令人讨厌,但我在编写 PHP 时一直使用 PHPMyAdmin 来调试数据库问题.默认情况下,它按主键升序对表进行排序.99% 的情况下,我宁愿将最新数据(我的测试数据)默认显示在顶部,而不是保存无用的前几条记录.

有没有办法将 PHPMyAdmin 配置为默认显示最新记录?改变类似的行为?

解决方案

对于来到这里寻找答案的其他人:

在 phpMyAdmin 4.5.0 中,也许在更早的版本中,您可以设置 $cfg['TablePrimaryKeyOrder'] 配置如下:

$cfg['TablePrimaryKeyOrder'] = 'DESC';

<块引用>

这定义了表的默认排序顺序,有一个主键,当没有外部定义的排序顺序时.可接受的值:[‘NONE’、‘ASC’、‘DESC’]

如果表有一个主键并且没有对其应用其他排序,这将设置默认排序.

Even though its obnoxious in a lot of ways I use PHPMyAdmin all the time to debug database issues while writing PHP. By default it sorts tables by primary key ascending. 99% of the time I would rather have the newest data (my test data) shown at the top by default rather than the useless first few records ever saved.

Is there a way to configure PHPMyAdmin to show the newest records by default? To alter similar behavior?

解决方案

For anyone else who comes here looking for an answer:

In phpMyAdmin 4.5.0, maybe in earlier versions too, you can set the $cfg['TablePrimaryKeyOrder'] config like so:

$cfg['TablePrimaryKeyOrder'] = 'DESC';

This defines the default sort order for the tables, having a primary key, when there is no sort order defines externally. Acceptable values : [‘NONE’, ‘ASC’, ‘DESC’]

This sets the default sort if the table has a primary key and that no other sort has been applied to it.

相关文章