Re: mysql problems, need help quick
| From: | Shane Kelly | Date: | Tue, 11 Jun 2002 13:49:25 +0000 |
| Subject: | Re: mysql problems, need help quick | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-101548@lists.php.net to get a copy of this message | ||
not on auto increment...thats the point!
why would you need to get the #6 back anyway...
this is the fundementals of database theory... chances are the database is
using this autoincrement field as the PRIMARY KEY...in which case no
duplicates are allowed..
In terms of records...your id#7 has become record #6.
I can't think of any reason why loosing the #6 should affect anything you
want to do.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
"Hawk" <hw2k@barrysworld.com> wrote in message
news:20020611125202.40585.qmail@pb1.pair.com...
> I'm filling a database with info, and I'm using id as identifiers in the
> list, the id is auto increment, and I deleted one entry, now I have a hole
> in the database, is there any way to fix this?
> lets say I have
> 1
> 2
> 3
> 4
> 5
> 6
> And I deleted 6
> Now it looks like
> 1
> 2
> 3
> 4
> 5
> 7
> 8
> 9 and so on
>
> is there somewhere the "next" number is located ?
>
>
>