- 分库累计业务量SQL
SELECT d,sum(c) s from (SELECT date_format(create_time ,'%Y-%m-%d') d,count(*) c FROM record WHERE create_time BETWEEN '2021-01-01' AND '2021-01-31 23:59:59' GROUP BY d union all SELECT date_format(create_time ,'%Y-%m-%d'
SELECT d,sum(c) s from (SELECT date_format(create_time ,'%Y-%m-%d') d,count(*) c FROM record WHERE create_time BETWEEN '2021-01-01' AND '2021-01-31 23:59:59' GROUP BY d union all SELECT date_format(create_time ,'%Y-%m-%d'