Data Base Query - start from 101

Discussion in 'Databases' started by FindLostMoney, Nov 10, 2008.

Thread Status:
Not open for further replies.
  1. #1
    Hi All
    http://www.FindUnclaimedMoney.net is in process of adding 300,000+ IRS undeliverable tax refunds sent out as a part of the economic stimulus package announced by the Federal government.

    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
     
    FindLostMoney, Nov 10, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Use this
    ALTER TABLE table_name AUTO_INCREMENT = 101;
    Code (markup):
     
    mwasif, Nov 10, 2008 IP
Thread Status:
Not open for further replies.