I've tried to find a way to generate a list of consecutive numbers with a SELECT statement. I would like something like "Select ..." that would result the numbers between 1 and 20 on separate rows.
So far, the only solution I have found is to have a table with consecutive numbers from 1 to 1000, and then I can just select the range I want from that table. I've looked in the documentation, but haven't found anything about a nicer solution. If anyone knows of a better solution please share. Thanks in advance. Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
