List:General Discussion« Previous MessageNext Message »
From:spameden Date:March 12 2013 9:47pm
Subject:Re: auto_increment field behavior
View as plain text  
2013/3/13 Reindl Harald <h.reindl@stripped>:
>
>
> Am 12.03.2013 22:34, schrieb spameden:
>> NOTE: AUTO_INCREMENT is 32768 instead of 17923 ! So next inserted row
>> would have pc_id=32768.
>>
>> Please suggest if it's normal behavior or not
>
> what do you expect if a PRIMARY KEY record get's removed?
> re-use the same primary key?
> this is not the way a database is allowed to work

No, I do not want the same key, I just want the next key after I
insert 17922 records it should be 17923 ?

I didn't delete or modificate any records.

>
Thread
auto_increment field behaviorspameden12 Mar
  • Re: auto_increment field behaviorReindl Harald12 Mar
    • Re: auto_increment field behaviorspameden12 Mar
      • Re: auto_increment field behaviorspameden12 Mar
  • RE: auto_increment field behaviorRick James12 Mar
    • Re: auto_increment field behaviorspameden12 Mar
      • RE: auto_increment field behaviorRick James12 Mar
        • Re: auto_increment field behaviorspameden12 Mar
          • Re: auto_increment field behaviorspameden12 Mar
            • Re: auto_increment field behaviorspameden12 Mar
              • Re: auto_increment field behaviorspameden12 Mar