MySQL Forums
Forum List  »  Newbie

Re: default value for autoincrement primary key
Posted by: pearsojd
Date: August 18, 2004 03:43PM

Hi,

Firstly, depends on the table type you are using. With MyISAM and HEAP you can set initial values, for other handlers you can't but you can use a workaround (eg Insert a dummy record one less than the record you want to start with).

If you are using MyISAM syntax is along the lines of ;
create table mytable (attributes etc) auto_increment=101;

Check out this link for exact syntax:
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html

James

Options: ReplyQuote


Subject
Written By
Posted
August 18, 2004 03:42PM
Re: default value for autoincrement primary key
August 18, 2004 03:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.