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
Subject
Written By
Posted
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.