Jump to content

MySQL

- - - - -

  • Please log in to reply
1 reply to this topic

#1
Bioshox

Bioshox

    Programming Professional

  • Members
  • PipPipPipPipPip
  • 207 posts
hey

I have an ID field, set up like this:

Field Type Collation Attributes Null Default Extra Action
id int(11) No None AUTO_INCREMENT

And I'm guessing if I delete a row the ID will not carry on from e.g

13
14
15
17

As row 16 was deleted, is there any way to change this?

#2
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
  • Location:Karlstad, Sweden
  • Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
  • Learning:Java, C#
normally, there is no importancy to have an uninterrupted series of IDs. Are you really in need of an uninterrupted Id series?
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users