sql问题,去看看 麻烦大家看一下这贴,寻求解决办法http://topic.csdn.net/u/20100312/14/c5f1cf92-ae49-4c63-8ae1-347cd8bd4854.html?seed=1987461279&r=63882263#r_63882263 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> select * from t_dld11111;+------+-------+| id | reply |+------+-------+| 1 | 0 || 2 | 0 || 3 | 0 || 4 | 1 || 5 | 3 |+------+-------+5 rows in set (0.00 sec)mysql> select id -> from t_dld11111 -> order by if(reply>0,reply,id),id;+------+| id |+------+| 1 || 4 || 2 || 3 || 5 |+------+5 rows in set (0.00 sec)mysql> mysql> select GROUP_CONCAT(id ORDER BY if(reply>0,reply,id),id SEPARATOR ' ') -> from t_dld11111;+-----------------------------------------------------------------+| GROUP_CONCAT(id ORDER BY if(reply>0,reply,id),id SEPARATOR ' ') |+-----------------------------------------------------------------+| 1 4 2 3 5 |+-----------------------------------------------------------------+1 row in set (0.00 sec)mysql> mysql4.0 默认的字符集是多少? 新手提问,Mysql读取excel的方式 MYSQL的函数和存储过程能返回临时表吗? 有关无限循环的存储过程 关于上传数据库到服务器问题 数据库设计 请问,数据库 id 适合用 varchar类型吗? 对mysql varchar的疑问,请大家作答 同表数据更新 求教mysql语句, 详情见图片 想请教下,这条SQL语句有什么问题 求 一条SQL语句 ~~~~~~~~~~~~~~~~~~
+------+-------+
| id | reply |
+------+-------+
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 1 |
| 5 | 3 |
+------+-------+
5 rows in set (0.00 sec)mysql> select id
-> from t_dld11111
-> order by if(reply>0,reply,id),id;
+------+
| id |
+------+
| 1 |
| 4 |
| 2 |
| 3 |
| 5 |
+------+
5 rows in set (0.00 sec)mysql>
-> from t_dld11111;
+-----------------------------------------------------------------+
| GROUP_CONCAT(id ORDER BY if(reply>0,reply,id),id SEPARATOR ' ') |
+-----------------------------------------------------------------+
| 1 4 2 3 5 |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)mysql>