mysql中怎么获取前七天的日期

select * from audit_session where login_time<=(CurDate()-7) and login_time>='DATE_SUB(now() , INTERVAL 1 DAY) 00:00:00'

SELECT * FROM `tbl` WHERE id IN (

SELECT MAX(id) FROM `tbl`

WHERE createdat BETWEEN ADDDATE(DATE_FORMAT(NOW() ,"%Y-%m-%d"), INTERVAL -6 DAY) AND DATE_FORMAT(NOW(),'%Y-%m-%d')

GROUP BY DATE_FORMAT(createdat,'%Y-%m-%d')

)

前提你的表要有自增主键

---