Table to start from 101

Discussion in 'Databases' started by zed420, Nov 5, 2008.

0
  1. #1
    Hi All

    I wonder if someone can help me I've created a table but I want it to start at 101 and not from 0, How do i do this?

    Thank you
    zed
     
    zed420, Nov 5, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Run this:

    ALTER TABLE my_table_name AUTO_INCREMENT = 101;

    Normally you would do this on a command line prompt.
     
    jestep, Nov 5, 2008 IP
  3. zed420

    zed420 Member

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3


    Thanks jestep just what I wanted

    Zed
     
    zed420, Nov 5, 2008 IP
  4. niceindustry

    niceindustry Guest

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    oh i think you can ask the expert or find the answer from google
     
    niceindustry, Nov 7, 2008 IP