MySQL 排序
MySQL 大约 2434 字order by
select * from 表名 order by 列1 asc|desc,列2 asc|desc,...
select * from user order by age; (升序)
+----+-------+------+---------------------+--------+------+----------+
| id | name | age | birthday | gender | home | isdelete |
+----+-------+------+---------------------+--------+------+----------+
| 11 | admin | 0 | NULL | NULL | NULL | NULL |
| 6 | 曹值 | 18 | 2000-01-01 00:00:00 | | 魏 | |
| 5 | 曹丕 | 20 | 2000-01-01 00:00:00 | | 魏 | |
| 10 | 小乔 | 22 | 2000-01-01 00:00:00 | | 吴 | |
| 9 | 大乔 | 23 | 2000-01-01 00:00:00 | | 吴 | |
| 7 | 孙权 | 25 | 2000-01-01 00:00:00 | | 吴 | |
| 8 | 周瑜 | 25 | 2000-01-01 00:00:00 | | 吴 | |
| 3 | 张飞 | 35 | 2000-01-01 00:00:00 | | 蜀 | |
| 2 | 关羽 | 36 | 2000-01-01 00:00:00 | | 蜀 | |
| 1 | 刘备 | 37 | 2000-01-01 00:00:00 | | 蜀 | |
| 4 | 曹操 | 40 | 2000-01-01 00:00:00 | | 魏 | |
+----+-------+------+---------------------+--------+------+----------+
11 rows in set (0.00 sec)
默认按照列值从小到大排列
某些行列1
的值相同时,则按照列2
排序,以此类推
asc
从小到大排列,即升序desc
从大到小排序,即降序
select * from user order by age desc;
+----+-------+------+---------------------+--------+------+----------+
| id | name | age | birthday | gender | home | isdelete |
+----+-------+------+---------------------+--------+------+----------+
| 4 | 曹操 | 40 | 2000-01-01 00:00:00 | | 魏 | |
| 1 | 刘备 | 37 | 2000-01-01 00:00:00 | | 蜀 | |
| 2 | 关羽 | 36 | 2000-01-01 00:00:00 | | 蜀 | |
| 3 | 张飞 | 35 | 2000-01-01 00:00:00 | | 蜀 | |
| 7 | 孙权 | 25 | 2000-01-01 00:00:00 | | 吴 | |
| 8 | 周瑜 | 25 | 2000-01-01 00:00:00 | | 吴 | |
| 9 | 大乔 | 23 | 2000-01-01 00:00:00 | | 吴 | |
| 10 | 小乔 | 22 | 2000-01-01 00:00:00 | | 吴 | |
| 5 | 曹丕 | 20 | 2000-01-01 00:00:00 | | 魏 | |
| 6 | 曹值 | 18 | 2000-01-01 00:00:00 | | 魏 | |
| 11 | admin | 0 | NULL | NULL | NULL | NULL |
+----+-------+------+---------------------+--------+------+----------+
11 rows in set (0.00 sec)
阅读 1142 · 发布于 2019-04-07
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb扫描下方二维码关注公众号和小程序↓↓↓

昵称:
随便看看
换一批
-
Spring Boot logback springProperty 设置默认值阅读 4898
-
Java中的串行、并行、CMS 垃圾收集器阅读 1000
-
Java 并发编程之 happens-before 7 条规则阅读 1115
-
Maven 常用命令阅读 156
-
面试题:Java 内存结构与内存模型阅读 3007
-
Java jstat 监控远程服务阅读 1540
-
PHP 时间加减阅读 2050
-
Android 使用 adb wm 命令调整手机分辨率阅读 24941
-
Java 并发编程之 AQS ReentrantLock await signal 源码解析阅读 1435
-
Redis 执行 Lua 脚本抛出 StatusOutput does not support set(long) 异常阅读 7912