SET @v1 = '';
SET @v2 = '';

SET @Query = CONCAT('SELECT sum(colName1), sum(colName2) INTO @v1, @v2 FROM tableName WHERE id=1 ');
PREPARE stmt FROM @Query;

EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @Query = CONCAT('SELECT id, name,'@v1' as value1, '@v2' as value2 FROM tableName WHERE id=1 ');
PREPARE stmt FROM @Query;

EXECUTE stmt;
DEALLOCATE PREPARE stmt;