Sequential Auto-Increment ?
Posted: Sat Jun 18, 2005 5:12 pm
Hi guys,
I want to have an ID column with sequential integers so I can choose random ID numbers and select those rows. The problem is when I delete a row; it leaves a hole.
How should I handle this ? It would be great if I could shift them all down, so if I have 0,1,2,3,4 and remove ID 2 it becomes 0,1,2,3 and *not* 0,1,3,4.
Any help is appreciated.
Robert
I want to have an ID column with sequential integers so I can choose random ID numbers and select those rows. The problem is when I delete a row; it leaves a hole.
How should I handle this ? It would be great if I could shift them all down, so if I have 0,1,2,3,4 and remove ID 2 it becomes 0,1,2,3 and *not* 0,1,3,4.
Any help is appreciated.
Robert