V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 4286 days ago, the information mentioned may be changed or developed.
如下：
select count(*) as num from a where id in (11,12,9,4,15) group by id;
这样输出数据后，不是按照 id的数据顺序 11,12,9,4,15 输出的
求解决方案 3Q！
select count(*) as num from a where id in (11,12,9,4,15) group by id;
这样输出数据后，不是按照 id的数据顺序 11,12,9,4,15 输出的
求解决方案 3Q！
 |
1
yangqi Aug 5, 2014  3
ORDER BY FIELD(ID,11,12,9,4,15)
|
 |
2
hcy Aug 5, 2014 1
order by field(id ,11,12,9,4,15）
试下这个。 |
 |
3
hellohacker OP |
Select Language