summing up column content with SQL cmd

[[deleted]]

hi,

for my problem i have a solution using mysql_fetch_array() and then summing up the single returned values. BUT:

i have the feeling that there is a better and faster soloution usig an SQl command.

I have a table on my db and a column named hits (int). There are about 100 rows in this table and i want to make a sql command which gets the value of every row ("hits-column") and sums this up into one variable.

e.g

hits

5
6
7

1
2
4
57
8
45

the sql command should return me the sum of all these integers.

any ideas how this sql-cmd should look like ?

thanks in advance

ali

[Anon]

SELECT SUM(hits) FROM table

Diego