default value for Auto increment

[praveena mani]

how to specify a default value for auto increment??
for innodb engine..

[code green]

The auto-increment IS the default

[pbmods]

Heya, Praveena.

Note that MySQL doesn't care what the AUTO_INCREMENT value for the table is, so long as it is unique. There's no reason why your records have to start with ID 1, for example.

But if you're dead-set on changing it:
[code=mysql]
ALTER TABLE `table name` AUTO_INCREMENT= new_value;
[/code]