Setting next AUTOINCREMENT value

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 3857

• Average Rating :
  

•  

• Total Votes: 36 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
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6

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.

---