Monday, August 8, 2011

Mysql set auto increment start value

In default, auto increment values are started in 0(zero). Suppose you, want to start value auto increment with 1234, use the following command after table creation.

ALTER TABLE TableName AUTO_INCREMENT=1234

No comments:

Post a Comment