I have a simple question I am sure, but I am just learning MySQL so here goes. I have a table named Bids and I have several rows in the table one of which is named bidquantity. Here is the command I am using for my result.
SELECT bidquantity from Bids TOTAL;
The result is this:
bidquantity
1
1
4
10
1
1
23
66
3
1
17
1
1
1
43
4
7
14
2
76
1
1
21
46
9
2
This is working, but what I need to do is total the column so that it adds up all of the column to give me a total number of bids. Can someone point me in the right direction? Do me justice, O God, and fight my fight against a faithless people; from the deceitful and impious man rescue me.
Psalm 43:1
SELECT bidquantity from Bids TOTAL;
The result is this:
bidquantity
1
1
4
10
1
1
23
66
3
1
17
1
1
1
43
4
7
14
2
76
1
1
21
46
9
2
This is working, but what I need to do is total the column so that it adds up all of the column to give me a total number of bids. Can someone point me in the right direction? Do me justice, O God, and fight my fight against a faithless people; from the deceitful and impious man rescue me.
Psalm 43:1