#1
  1. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Just a curiosity thing, but is there a way to set the auto_increment function of mysql to start all number with a "0" so that the id number or whatever is incremented as: 001, 002, 050 etc??

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Yes, use ZEROFILL in your table declaration:

    create table whatever (id integer unsigned zerofill auto_increment primary key,.....

  4. #3
  5. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Guess I should spend a little more time in the darn books

    Thanks for the quick response.

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.

IMN logo majestic logo threadwatch logo seochat tools logo