List:General Discussion« Previous MessageNext Message »
From:daniel Date:May 2 2002 9:55pm
Subject:inserting into the lowest possible id
View as plain text  
lets say you have a table like this

id   |   data0   |   data1   |   ...
0    |   xxxxx   |   yyyyy   |   ...
1    |   xxxxx   |   yyyyy   |   ...
2    |   xxxxx   |   yyyyy   |   ...
3    |   xxxxx   |   yyyyy   |   ...
4    |   xxxxx   |   yyyyy   |   ...
7    |   xxxxx   |   yyyyy   |   ...

what if when i performed an INSERT query again, i wanted that id to NOT be
8, but
be 5 since it's the lowest available id.  what would i do?


_________________________________
daniel a. g. quinn
starving programmer

fools in a country delay the independence of its people
  - jomo Kenyatta


Thread
inserting into the lowest possible iddaniel2 May
  • Re: inserting into the lowest possible idDan Nelson3 May
  • Re: inserting into the lowest possible idGelu3 May