totaling a column of integers

[Jon7800]

I'm using mysql.
I have a column called Bid for each row.
I want to total the integers in this column for all the rows.

For example, I have 3 rows, with integers 36, 37 and 22 in the column called Bid.

How can I total these rows? (Total = 95 for all 3 rows)

Any help is greatly appreciated!

Thanks,
Jon

[dopey]

select sum(Bid) from mytable

should do it :-)

[Jon7800]

Thank you! Got it.