MySQL sort by a column by default in phpMyAdmin -


i added new index in table , phpmyadmin sorting rows column default. how make phpmyadmin sort rows id column instead of url column 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 ; 

you can resolve issue adding default order tableusing alter table query.

query: alter table links order id;

if not specify order clause in clause, rows sort default "id" column.


Comments

Popular posts from this blog

javascript - Count length of each class -

What design pattern is this code in Javascript? -

hadoop - Restrict secondarynamenode to be installed and run on any other node in the cluster -