Hi,
> i actually need the id's with no row returned as if they
> were there (but with default values)... they do not need
> to be inserted into the table, just returned as if they
> were in there.
The only way I can think of would be to create a table with
all the values (ids) you ne
counter.number = your_table.id
order by your_table.id
TK
> -Opprinnelig melding-
> Fra: Jamie Burns [mailto:[EMAIL PROTECTED]]
> Sendt: 27. november 2001 14:28
> Til: sherzodR
> Kopi: [EMAIL PROTECTED]
> Emne: Re: can i do this with sql?
>
>
> i actually need the id
ion.co.uk> cc: <[EMAIL PROTECTED]>
Subject: Re: can i do this
with sql?
ns" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 1:24 PM
Subject: Re: can i do this with sql?
>
>
> i belive you want..:
>
> SELECT * FROM your_table WHERE id < 9 ORDER BY id LIMIT 9;
>
> But when it comes to generating missing
i belive you want..:
SELECT * FROM your_table WHERE id < 9 ORDER BY id LIMIT 9;
But when it comes to generating missing items... I'm not sure if
i got you right though, but they should exist. MySQL cannot
make the rows that do not exist
Jamie Burns wrote:
: Hi all,
:
: I have a table like
Hi all,
I have a table like this:
iddatayear
1 201
2 201
6 201
7 201
8 201
11201
What i want to be able to get is these results from an sql query (given that
i want id's 1-9):