SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation cannot change auto_increment number (was "Some help please")

    Well i'm having some database problems my auto_increment is set on 692120 i've been trying to change it to 1095 manually & by using the database commands but it's still not changing , everytime i change it , it shows the command yes...
    ALTER TABLE `userdb` AUTO_INCREMENT =1097 but it does not change..

    it keeps staying at 692120.

    Any suggestion here?

  2. #2
    SitePoint Evangelist
    Join Date
    Aug 2005
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What type of table are you using ?
    Note that this feature is available for InnoDB tables only as of MySQL 4.1.12.
    You can delete this column then re-add it.
    Computers and Fire ...
    In the hands of the inexperienced or uneducated,
    the results can be disastrous.
    While the professional can tame, master even conquer.

  3. #3
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My mysql is MySQL client version: 4.1.21

    Server version: 4.1.21-standard

    Deleting the id column hmm finalwarrior.net is my game & i got members already signup dunno i think deleting it will cause something.

  4. #4
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok i've figure it out their was an id that was 692119 so that messed it up so i couldn't of changed it to 1095 iight


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •