Shared Tutorials
Tutorials Shared by the Internet Community
Advertisements
| Top Tutorials | New Tutorials | Submit | Login | Register |
Tutorial Basic 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: 3831
Total Votes: 36 votes
Average Rating: 2.5 out of 5
Category: MySQL/Misc
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.
Rating Detail
| Stars | Percentage | Total Vote |
|---|---|---|
![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |




16.67%

16.67%

16.67%

16.67%

16.67%