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 4283 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