页次: 1
mysql 中对结果是可以排序的。
首先创建一个表
http://www.ipbbs.net/viewtopic.php?id=165
按照gid 排序
mysql> select * from goods order by v_id; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 1 | aaa | 1 | 1.10 | | 4 | bbb | 1 | 4.10 | | 7 | ccc | 1 | 7.10 | | 2 | aaa | 2 | 2.10 | | 5 | bbb | 2 | 5.10 | | 8 | ccc | 2 | 8.10 | | 3 | aaa | 3 | 3.10 | | 6 | bbb | 3 | 6.10 | | 9 | ccc | 3 | 9.10 | +------+--------+------+---------+ 9 rows in set (0.00 sec)
如果想用逆序可以 v_id desc
mysql> select * from goods order by v_id desc; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 3 | aaa | 3 | 3.10 | | 6 | bbb | 3 | 6.10 | | 9 | ccc | 3 | 9.10 | | 2 | aaa | 2 | 2.10 | | 5 | bbb | 2 | 5.10 | | 8 | ccc | 2 | 8.10 | | 1 | aaa | 1 | 1.10 | | 4 | bbb | 1 | 4.10 | | 7 | ccc | 1 | 7.10 | +------+--------+------+---------+ 9 rows in set (0.00 sec)
如果在上面的基础上想让价格从高到底排序
mysql> select * from goods order by v_id desc , g_price desc; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 9 | ccc | 3 | 9.10 | | 6 | bbb | 3 | 6.10 | | 3 | aaa | 3 | 3.10 | | 8 | ccc | 2 | 8.10 | | 5 | bbb | 2 | 5.10 | | 2 | aaa | 2 | 2.10 | | 7 | ccc | 1 | 7.10 | | 4 | bbb | 1 | 4.10 | | 1 | aaa | 1 | 1.10 | +------+--------+------+---------+ 9 rows in set (0.00 sec)
排序可以对多个字段一起排序
ipbbs.net
离线
页次: 1