Addition code for mysql?

[shams]

hi,
how i can get the sum of the integers of one column?

[stuart]

Is it not just the count function? SELECT COUNT(field) FROM table

[trevayne]

hello i guess i have a similar question regarding getting the sum of integers in one column.

well if youre going to use SELECT COUNT(FIELD) FROM TABLE . you can only get the number of data in that table or should i say the number of rows.

+----+--------+------------+------+
| id | c_code | date | peso |
+----+--------+------------+------+
| 74 | 10 | 1254-07-08 | 564 |
| 75 | 11 | 1235-05-06 | 23 |
| 78 | 4 | 1236-08-07 | 564 |
| 79 | 5 | 1254-07-08 | 564 |
| 82 | 12 | 1235-08-07 | 654 |
| 83 | 13 | 1245-05-06 | 321 |

well i have this table and i want to add the values all inside the peso column,
hmm heheeh and i cant quite get the proper query to perform.
tnx,.

[vladimir_cz]

just add one calulated column with next way:
select peso, peso*1.2 as peso_with_tax from <table>

or just sum?
select sum(peso) from table where...
if need, add group by for calculate sums for each date, some code, etc.

[gesf]

SELECT SUM(peso) AS 'Real sum of field values';

For MySQL 5.0 users... use Triggers!

[Xnuiem]

how would triggers help get the sum of a column?

[gesf]

Got it I ment the examples on that page.

[Xnuiem]

You are trigger happy my friend!