reset all to defaults

  • Resolved hoolooweb

    (@hoolooweb)


    4 years, 11 months ago

    hi
    i want to restore user id start at 1 or another custom number for example 20001100 and start at 8 digits number
    please help me

Viewing 3 replies - 1 through 3 (of 3 total)

  • I have the same problem, please someone help us!!

    Hi!

    The next user id number is controlled by an MySQL auto_increment field.

    I’m afraid it’s not possible to do what you want. From the MySQL manual:

    You cannot reset the counter to a value less than or equal to any that have already been used. For MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum plus one. For InnoDB, if the value is less than the current maximum value in the column, no error occurs and the current sequence value is not changed.

    Why do you need to do this?

    Marking as resolved

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘reset all to defaults’ is closed to new replies.