[RESOLVED] MySQL auto increment start value

[[deleted]]

Hello.
I know that with MS databases, you can specify a seed value for an auto increment field. Does MySQL have a feature like this? I'd rather not give customers order IDs like 00000056 becuase it's too obvious that the software is new.

[jjfletch]

I think all you need to do is set the starting value:

AUTO_INCREMENT = 50000

[Roger_Ramjet]

Yes you can http://dev.mysql.com/doc/mysql/en/example-auto-increment.html

[[deleted]]

Thanks. I overlooked that.