mysql怎么获取当前时间 MYSQL查询一周内的数据(最近7天的)怎么写？

MYSQL查询一周内的数据(最近7天的)怎么写？date(column_time)查询一年：select * from table where DATE_SUB(CURDATE()， INTERVA

MYSQL查询一周内的数据(最近7天的)怎么写？

date(column_time)查询一年：select * from table where DATE_SUB(CURDATE()， INTERVAL 1 YEAR) DATE_ADD((select createdate from tb_equity ORDER BY createdate DESC limit 1) ，INTERVAL -7 day)and (select createdate from tb_equity ORDER BY createdate DESC limit 1) >= createdate3，sql查询表中的重复数据select * from 表名 where 字段名 in (select 字段名 from 表名 group by 字段名 HAVING COUNT(*) > 1) order by 表名

mysql查询一周内每天的记录数？

$re = mysql_query("SELECT count(*) as n， (TO_DAYS( NOW( ) ) - TO_DAYS( regtime)) as `d` FROM members group by TO_DAYS( regtime) having d " echo $rc["n"] //这个是数量}