Here's a quick hack, but you need to have another
table guaranteed to contain 1000 or more rows:
create temp table n( i int auto_increment not null, primary key(i));
insert into n select null from BIG_TABLE limit 1000;
regards,
Martin
On Mon, 2003-06-09 at 15:00, Martin Szabo wrote:
> I've
"Martin Szabo" <[EMAIL PROTECTED]> wrote:
> 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
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,
