mysql에서 열 합계를 구현하는 방법

select sum(yourColumnName1) as anyVariableName1,sum(yourColumnName2) as anyVariableName2,sum(yourColumnName3) as anyVariableName3,............N from yourTableName;

mysql> create table SumDemoOnColumns
   −> (
   −> First int,  
   −> Second int,
   −> Third int
   −> );

mysql> insert into SumDemoOnColumns values(10,20,30);
mysql> insert into SumDemoOnColumns values(40,50,60);
mysql> insert into SumDemoOnColumns values(70,80,90);
mysql> insert into SumDemoOnColumns values(100,110,120);

mysql> select *from SumDemoOnColumns;

mysql> select sum(First) as First,sum(Second) as Second,sum(Third) as Third from SumDemoOnColumns;