Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    New Jersey
    Posts
    39

    Unanswered: re-setting auto_increment

    After some testing I'll be deleting all the data from a number of tables. How does one re-set the auto_increment index back to 0 ?

  2. #2
    Join Date
    Feb 2002
    Location
    New Jersey
    Posts
    39
    Drum roll please...

    answer is:

    ALTER TABLE tbl_name AUTO_INCREMENT = 1;

    Pretty straight forward

Posting Permissions

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