mysql 一个表中根据日期求和

select book_subtime,sum(book_count) book_count

from n_column as n1, n_column_count as n2 where n1.column_xiaoshuo_state=1 and n1.column_id = n2.column_id

group by book_subtime

假设你的表名为table，日期型字段为date, 把下面语句中的'YYYY-MM-DD HHMMSS'换成实际的日期即可：

select * from table where date >(DATE_ADD('YYYY-MM-DD HHMMSS', INTERVAL 5 DAY))

---