MySQL默认在phpMyAdmin中按列排序 [英] MySQL sort by a column by default in phpMyAdmin

问题描述

我在表中添加了一个新索引，现在phpMyAdmin默认情况下按该列对行进行排序.如何使phpMyAdmin默认按id列而不是url列对行进行排序?

I added a new index in my table and now phpMyAdmin is sorting the rows by that column by default. How do I make phpMyAdmin sort the rows by the id column instead of the url column by default?

CREATE TABLE IF NOT EXISTS `links` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=343959 ;

推荐答案

您可以通过使用alter table查询将默认顺序添加到表中来解决此问题.

You can resolve this issue by adding default order by to the tableusing the alter table query.

查询:按ID更改表links的顺序；

QUERY: alter table links order by id;

如果您未在where子句中指定任何order by子句，则行将默认在"id"列中排序.

If you not specify any order by clause in where clause, then rows will sort by default "id" column.

这篇关于MySQL默认在phpMyAdmin中按列排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！