如何在 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.
相关文章