我的环境:
django django-rest-framework angular highcharts-ng
数据库 mysql
我目前的 sql 如下:
SELECT count(1) as num,DATE_FORMAT(created_at, '%Y-%m-%d') as riqi FROM Mytable group by (riqi) order by created_at desc limit 30 ;
输入内容如下:
num | riqi
2 | 2012-11-11
1 | 2012-11-12
1 | 2012-11-13
1 | 2012-11-14
1 | 2012-11-15
1 | 2012-11-16
然后输出到客户端 成了如下格式:
[{"num":2,"riqi":"2015-09-22"},{"num":1,"riqi":"2015-09-16"},{"num":1,"riqi":"2015-09-10"}]
这样的格式 无法 直接用于 highcharts
所以我想,让 mysql 输出为:
num | riqi
2,1,1 | 2015-09-22,2015-09-23,2015-09-24
如此的话,我就可以在客户端,就可以直接把 2 个值传递给 highcharts 的 categories 和 series 了