in Microsoft sql server 2005 or later,it is easier to generate unique numbers using the database server directly. you only specify the IDENTITY specification say 10000 and an incremental value say 1. this will generate numbers from 10000 upwards and at no time a number can be repeated or used by a different row(even if you delete sql will count the last number as being used and point next).
How can you do that using mysql server ? my aim is to auto-generate uniform and sequential numbers by using the database server itself.
...sorry for my bad english.. i speak kirwanda.