mysql查询当天，当月，当年的总数放在同一条记录

2019独角兽企业重金招聘Python工程师标准>>>

SELECT sum(1) as years,(select sum(1) from `member` where type=1 and month(regtime)=month(now())) as months,

(select sum(1) from `member` where day(regtime)=day(now()))as days FROM `member` where year(regtime)=year(now())

本人用到的mysql语句

$sql="select count(*) as count from attendance where uid='{$fromUsername}' and month(sign_time) = month(NOW()) and year(sign_time)=year(now()) order by `sign_time` desc";
$data = getData( $sql );
$contentStr .= "\n本月已签到".$data[0]['count']."天\n";

另一种方法

select * from tbname where date_format(tbname.colstime,'%Y-%m-%d')=now()

转载于:https://my.oschina.net/shunshun/blog/143407