What is the best way in mysql to generate a series of numbers in a given range? The application I have in mind is to write a report query that returns a row for every number, regardless of whether there is any data to report. An example in its simplest form might be: SELECT numbers.num, COUNT(a...