sql 统计来看看

Question

如图数据库记录的是这样的数据 import_time 从2017-11-01 到2017-11-31 一个月的每一天

现在需要统计出 每一天的记录数 保存为count变量

需要 得到类似下面数组哪样的数据 sql 语句怎么写尼 大神

array(25) {
  [0]=>
  array(37) {
   ["m_id"]=>
    string(3) "1"
    ["import_time"]=>
    string(10) "2017-11-04"
    ["cout"]=>
    string(10) "3"
  }
  [1]=>
  array(37) {
    ["m_id"]=>
    string(3) "2"
    ["import_time"]=>
    string(10) "2017-11-05"
    ["cout"]=>
    string(10) "2"
  }

Answer 1

select m_id,import_time,count(m_id) as count from table where import_time between 2017-11-01 and 2017-11-31 group by import_time

Answer 2

select import_time as days,count(*) counts from youtable group by days order by import_time desc

Answer 3

--亲测无误

SELECT COUNT(import_time) AS [COUNT] FROM [3d_De] WHERE import_time>'2017-11-01' AND import_time<'2017-11-31' GROUP BY import_time