Autoincrement
I'm wondering if it's possible to start an autoincrement integer field on a MySQL database to start at a specific number, say 1000.
View RepliesI'm wondering if it's possible to start an autoincrement integer field on a MySQL database to start at a specific number, say 1000.
View Repliesi am using access and in a table, I want a field with autonumber but starting from 100 or 1000 rather than 1! can it be possible (starting from 1000 and incremented by 1)?
View Replies View RelatedI m using MSQL and I m trying to create table where the first column is autoincremented, this, however, generates a syntax error. I can t figure out the problem:
Create Table tblAuthor (ID int(11) auto_increment,AuthorName varchar(200), primary key(ID));
Error Message: Line 1: Incorrect syntax near 'auto_increment'.