Changing the number auto_increment starts from

[simonpearce]

Hello!

When I create a new table, I want a field to use auto_increment but I'd like the number to start from 100 rather than 0 - is that possible?

I'm quite new to MySQL, but can't find anything in the docs.

I'm using MyISAM if that makes any difference!

Thanks all

Simon

 

[simonpearce]

Found this now!

ALTER TABLE customers AUTO_INCREMENT = 100;