mysql Q

Out of context: Reply #2

  • Started
  • Last post
  • 7 Responses
  • ********
    0

    Why do you not have it sequential?

    You’re executing an unnecessary query to get the next ... sequential ... id.

    Always have auto-increment on if you are going to have an Unique ID column.

    If you don’t like the starting number (0 or 1 or whatever) you can always set it to something higher.

    I usually bust ones to 1000, or 100000, depending on the data I am going to be holding in the table.

View thread