How do I make my ID field start from a specific number

[blaises]

Hi all,

I have an order table in mysql database and need to make the OrderId field entry start from a 5 figure number with an increment of 1. Any ideas how I can do this?

 

[sleipnir214]

What version of MySQL are you running?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[blaises]

I think its version 4

 

[sleipnir214]

Make sure of the version -- it makes a difference.

MySQL version 4.x supports the statement:

alter table <tablename> auto_increment = <starting number>;


In MySQL 3.x, if you insert a record and set a value for the auto_increment column, the server will begin generating auto_incrmement numbers from that value. It's the only way to set a starting value.

You can then delete that record, but do not perform a &quot;DELETE from <tablename>&quot; query that does not have a WHERE clause. MySQL, in order to speed &quot;DELETE from <tablename>&quot; queries, will drop and recreate the table, which will reset the auto_increment start value back to 1.

MySQL's auto_increment always increments by 1.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!