mysql对多行的多列进行对应求和

select sum(column1),sum(column2) from table1 where XXXX;