Monday, February 14, 2011

How to change the autoincrement value in a mysql table

Initially when we create a new table with auto increment filed, the values start from 1. After some time if we want to set auto increment value to a different value, then we will use the following command in mysql.

alter table members  Engine=MyISAM checksum=1 auto_increment=1000 comment='' delay_key_write=1 row_format=dynamic charset=latin1 collate=latin1_swedish_ci

No comments:

Post a Comment