On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
<[EMAIL PROTECTED]> wrote:
>hi all,
>
>could anyone tell me how to make a primary key to AUTO INCREMENT. The
>document is not exactly very explainatory about it :)
>
>Thankx in advance ...
>
>
>
>Mayuresh
>
>
Try first creating a sequence and then using the sequence as a default
value in your table:
-- STEP 1: create sequence
create sequence mytableid_seq;
-- STEP 2: create table
create table mytable (
id int default nextval ('mytableid_seq'),
anyvalue varchar
primary key (id));
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
