List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:March 12 2013 9:39pm
Subject:Re: auto_increment field behavior
View as plain text  

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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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