mysql查询表数据时，怎么把数据排序呢，我和大师分享一下排序方式。我写的经验对你进修mysql有帮忙的话，给我投票、点赞或者保藏！
工具/原料
- mysql、sqlyog
方式/步骤
- 1
登录mysql，在test数据库中新建一个表：
Create Table
CREATE TABLE `shoufei` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shijian` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `xiangmu` varchar(20) NOT NULL, `jiage` float NOT NULL, `shuliang` int(11) NOT NULL, `jine` float DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
- 2
在表中增添数据：
insert into `shoufei` (`id`, `shijian`, `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;
