Daniel,
'auto_increment' won't do that job for you and maybe it's not the right way
to think about it anyway. You really only want to use 'auto_increment' for
records that need to maintain serial numbers. If you are deleting records
and wanting to use the 'deleted' number then your 'serial number'
"Daniel Crompton" <[EMAIL PROTECTED]> wrote:
> I have one column as an auto increment for adding numbers:
>
> 1
> 2
> 3
> 4
> 5
>
> If i delete row 3 then add a new row and view the results i get:
>
> 1
> 2
> 4
> 5
> 6
>
> As you can see 3 has been deleted and its now added 6!
>
> Is this norm
> I have one column as an auto increment for adding numbers:
>
> 1
> 2
> 3
> 4
> 5
>
> If i delete row 3 then add a new row and view the results i get:
>
> 1
> 2
> 4
> 5
> 6
>
> As you can see 3 has been deleted and its now added 6!
>
> Is this normal?. How can i get it to always display numbers i
That is normal and you do NOT want it to display numbers in sequence.
Lets say I use auto-increment column for primary key, lets also say that
I made a mistake while coding and deleted someone's account (account #3)
from the account table, but forgot to delete the corresponding entry
from the balan
