Sql sum values ​​in 100 columns?

Question

SQL

There are columns with numbers
column1,column2,column3...........,column100 It is
necessary to calculate the sum of all 100 columns It is
natural to write
select column1+column2+column3+....+column100 is not an option
What is the way to do this( in a loop there or something else) I
use Sqlite

Answer 1

Just:
And the SQL query itself must be assembled by some kind of builder or string builder. I don't think this will be a problem.

Answer 2

It's just some kind of unthinkable database structure ... I won't ask why.
You can programmatically compose an SQL query like the example below in Ruby language,

select_clause = ""
for i in (1..99) do
  select_clause += "column" + i.to_s + "+"  # i.to_s конвертирует число в строковое представление
end
select_clause += "column100"
sql_statement = "SELECT " + select_clause + " FROM table_name"

Answer 3

I support that the database structure is unthinkable
, but I would make a calculated column with a stored value

Answer 4

Without the use of programming languages, purely using the SQLITE command line, you can do this:
Let's say this is the initial data (like the author of the request?):

CREATE TABLE if not exists mytable (id integer, column1 integer, column2 integer, column3 integer);
insert into mytable values (1, 54, 88, 99);
insert into mytable values (2, 22, 12, 778);
insert into mytable values (3, 0, 123, 88);
insert into mytable values (4, 7, 42, 35);
insert into mytable values (5, 5, 47, 23);

Then the sum of the columns can be obtained like this:

create table if not exists temp(a text, b text, c text, d text, e text, f text);

.out temp.txt
pragma table_info('mytable');
.out stdout

.import temp.txt temp

.out temp.txt
select 'select ' || group_concat(b, '+') || ' as resultColumn from mytable;' from temp where b like 'column%';
.out stdout
drop table temp;

.read temp.txt

Commands can be slipped into SQLITE in the form of a script, then you don’t even need to type them.