Mysql question...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 4Pics
    Confirmed User
    • Dec 2001
    • 7952

    #1

    Mysql question...

    How do you alter the starting #?

    Like if you set a id # to autoincrement it starts at 1, I want it to start at like 10000. How do I do that.
  • Spudstr
    Confirmed User
    • Jan 2003
    • 2321

    #2
    ALTER TABLE `field` AUTO_INCREMENT = 10000
    Managed Hosting - Colocation - Network Services
    Yellow Fiber Networks
    icq: 19876563

    Comment

    • 4Pics
      Confirmed User
      • Dec 2001
      • 7952

      #3
      Originally posted by Spudstr
      ALTER TABLE `field` AUTO_INCREMENT = 10000
      thanks

      Comment

      Working...