麻烦大家看一下这贴,寻求解决办法
http://topic.csdn.net/u/20100312/14/c5f1cf92-ae49-4c63-8ae1-347cd8bd4854.html?seed=1987461279&r=63882263#r_63882263
http://topic.csdn.net/u/20100312/14/c5f1cf92-ae49-4c63-8ae1-347cd8bd4854.html?seed=1987461279&r=63882263#r_63882263
解决方案 »
- create_mysql脚本文件是在哪个文件夹下面的
- mysql 游标多重循环
- mysqlbinlog无法恢复数据,问题超级严重,高手速进。谢谢。
- mysql 表类型innodb的重大bug
- PostgreSQL 8.3 pgadmin III 不知为何图形界面不能添加 或修改数据??
- phpmyadmin如何装呀,是不是必须要先安装php环境呀?
- mysqldump批量备份数据库报错
- 请问怎么把别人的数据库导入到MYSQL里面?
- mysql错误:Can't create a new thread (errno 12).
- #2003 - Can't connect to MySQL server on 'localhost' (10048)
- 想请教下,这条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>