Q: Seed of primary key

  • Thread starter Thread starter Geoff Jones
  • Start date Start date
G

Geoff Jones

Hi

How do I set the starting value of an autoincrementing primary key?

Thanks

Geoff
 
1. Run the following insert query.

INSERT INTO YourTable (YourAutoNumberField)
Values (1000);

2. Open the table and delete that record you just inserted.
3. The next created record will have a value of 1001.

Obviously, you need to replace 1000 with the value that is one lower than
where you want it to start.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Table Issues 3
One to one relationship 0
Creating a key consisting of two columns 1
Primary Keys on Forms 5
data merge 0
About autoincrement 1
Relationships and Keys 18
generate primary key by expression 5

Back
Top