mysql数据库表中的数据排序

1、登录mysql，在test数据库中新建一个表： Create Table垓矗梅硗 CREATETABLE`shoufei`(`id`int(11)NOTNULLAUTO_INCREMENT,`shijian`timestampNOTNULLDEFAULTCURRENT_TIMESTAMP,`xiangmu`varchar(20)NOTNULL,`jiage`floatNOTNULL,`shuliang`int(11)NOTNULL,`jine`floatDEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=6DEFAULTCHARSET=utf8

2、在表中增加数据：insert into `shoufei` (`id`, `shi门钙蹲茌jian`, `xiangmu`, 际吨孔鳝`jiage`, `shuliang`, `jine`) values('1','2019-01-28 11:15:52','银翘解毒丸','2','10','20');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('2','2019-01-28 11:15:59','甘草片','20','2','30');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('3','2019-01-28 11:16:04','阿莫西林','20','2','40');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('4','2019-01-28 11:16:08','午时茶','8','1','8');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('5','2019-01-28 11:16:12','银翘解毒丸','2','10','20');

3、表shoufei，主键是id，如果不指定排序就是按照主键索引顺序排列。SELECT * FROM shoufei;

4、查询表中数据按照xiangmu升序排列：SELECT * FROM shoufei ORDER BY xiangmu ASC;

5、查询表中数据按照shuliang降序排列：SELECT * FROM shoufei ORDER BY shuliang DESC;

6、查询表中数据按照jiage升序、id升序排列：SELECT * FROM shoufei ORDER BY jiage ASC,id ASC;