摘要：where DATE_FORMAT(ndate,'%Y-%m')=date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y-%m')//上月统计 select "本日" ndate,sum(xj) xj,sum(kk) kk,sum(qk) qk,sum(hk) hk,sum(zdxh) zdxh,sum(hys) hys,sum(xks) xks,sum(yyxh) yyxh from tj_yingyetj where ndate = curdate() select "昨日&q 阅读全文