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 Replies


ADVERTISEMENT

Autoincrement In Field

i 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 Related

Quick Question (Autoincrement)

I 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'.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved