摘要:按年汇总,统计: select sum(mymoney) as totalmoney, count(*) as sheets from mytable group by date_format(col, '%Y'); 按月汇总,统计: select sum(mymoney) as totalmone 阅读全文
posted @ 2018-01-31 10:27 丨Mars 阅读 (2824) 评论 (0) 编辑