SQL problem

[Replies] [Reply] [View by Thread] [Help]
[Back To Programming]

Gamma LtKer MDalby

I have a database with the columns `id` and `data` the `id` column contains different numbers with values between 1 and 999 .

e.g. SELECT * FROM database would return

-----------
|ID ||Data|
-----------
|2 ||dret|
|4 ||asdf|
|7 ||asdd|
-----------

What i want to do fill in the gaps in `data` so that the column has all the numbers from 1 to 999 WITHOUT going over the ones that are (I need to keep the data intact)

Desired Result..
SELECT * FROM database

-----------
|ID ||Data|
-----------
|2 ||dret|
|3 || |
|4 ||asdf|
|5 || |
|6 || |
|7 ||asdd|
|8 || |
|8 || |
|10 || |
-----------
etc...

Does anyone have a simple way to do this, I've been up since the early hours and my brain has switched off :-(

Replies:

>SQL problem - Gamma LtKer MDalby 2008-08-18 09:53:18 <
- RE: SQL problem - Epsilon Maj Pain in the Ass 2008-08-18 19:06:48
- RE: SQL problem - Ker sefo 2008-08-18 12:02:45
  - RE: SQL problem - Gamma LtKer MDalby 2008-08-18 13:04:45

Guest:
Subject:
Message:	On 2008-08-18 09:53:18, MDalby wrote >I have a database with the columns `id` and `data` the `id` column contains different numbers with values between 1 and 999 . > >e.g. SELECT * FROM database would return > >----------- >\|ID \|\|Data\| >----------- >\|2 \|\|dret\| >\|4 \|\|asdf\| >\|7 \|\|asdd\| >----------- > >What i want to do fill in the gaps in `data` so that the column has all the numbers from 1 to 999 WITHOUT going over the ones that are (I need to keep the data intact) > >Desired Result.. >SELECT * FROM database > >----------- >\|ID \|\|Data\| >----------- >\|2 \|\|dret\| >\|3 \|\| \| >\|4 \|\|asdf\| >\|5 \|\| \| >\|6 \|\| \| >\|7 \|\|asdd\| >\|8 \|\| \| >\|8 \|\| \| >\|10 \|\| \| >----------- >etc... > >Does anyone have a simple way to do this, I've been up since the early hours and my brain has switched off :-(
Signature:
Optional Image Link:
http://

CyberArmy::Forum v0.6
Generated In 0.02364 seconds