How to set a MySQL Table AUTO_INCREMENT

Posted on November 18, 2008 by Raymond

To start with an AUTO_INCREMENT value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

mysql> ALTER TABLE tbl AUTO_INCREMENT = 100;

About Raymond

I'm a Christian web developer from the Philippines. Sometimes I write also.

This entry was posted in MySQL, SQL and tagged MySQL. Bookmark the permalink.