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
Post a Comment