MySQL SUM()函数按条件求和

• 一般求和

select sum(money) from user group by id;

• 按条件求和

select sum(if(type=1,money,0)) from user group by id;