MySQL Select-Order by

Order by:

按照字段进行排序。

Order by 字段 升序|降序 (asc|desc).

默认升序 asc

校对规则 决定 排序关系。

 

允许多字段排序，指的是先按照第一个字段排序，如果不能区分，

才使用第二个字段，以此类推。

/*简单示例*/
use php_one;

create table t10(
a int
);

insert into t10 values(5);
insert into t10 values(10);
insert into t10 values(15);
insert into t10 values(7);
insert into t10 values(8);
insert into t10 values(50);
insert into t10 values(3);
insert into t10 values(1);
insert into t10 values(35);

select * from t10 order by a asc;   /*升序排列*/
select * from t10 order by a desc;  /*降序排列*/

create table t10_1(
a int,
b int
);

insert into t10_1 values(5,9);
insert into t10_1 values(10,15);
insert into t10_1 values(15,8);
insert into t10_1 values(15,9);
insert into t10_1 values(8,51);
insert into t10_1 values(50,15);
insert into t10_1 values(50,2);
insert into t10_1 values(1,9);
insert into t10_1 values(35,7);

select * from t10_1 order by a asc,b desc;
select * from t10_1 order by a asc,b asc;