Setting next AUTOINCREMENT value

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Setting next AUTOINCREMENT value

How to set next AUTO-INCREMENT value in MySQL database?
http://axdimensions.wordpress.com/2008/01/15/setting-next-autoincrement-value/
  • Total Hits: 17924

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 144 votes

  • Category: MySQL/MySQL Misc

  • Submitted on: 2008-04-15 01:20:49

  • Submitted By: Shekhar

  • Set as Favorite

Description:

By default, MySQL starts auto-incrementing from value 1. To start with value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

mysql> ALTER TABLE [tablename] AUTO_INCREMENT = [number];

An alternate way of doing this is, simply insert a row in your Table and enter the next auto-increment value.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.19%  55
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.42%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.81%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.11%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.47%  41

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements