Counting occurences of data falling betwen a series of limits (buckets)

[Peter Dzwig]

This ought to be trivial but...

I have a dataset in a MySQL DB which is about 30 rows wide and some 500+ rows deep - and this is a prototype of a much larger DB.

Think something like this:

Col_1 Col_2 Col_3 Col_4......
-----
500+ rows
-----

the data in (let's say) Col_2 is scattered between certain limits (say 1 to 9.5). What I want to do is create a number of buckets, let's say of width 0.01, and count up the number of values in Col_2 falling into each bucket.

The limits and the width of the buckets and hence the number of buckets need to be variable (other datasets have different ranges for Col_2)

The output should ideally be a table looking like:

BUCKET | NUMBER IN BUCKET

Bucket_1 | Count_1
Bucket_2 | Count_2
.
.
.
Bucket_last | Count_last

at this point no other data needs to appear in the new table.

FWIW the output data will be ultimately become a csv file for plotting.


It may just be getting late...

Thanks for any help that you can give,

Peter