" <[EMAIL PROTECTED]>
>To: "Harrison C. Fisk" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, "Paul
>DuBois" <[EMAIL PROTECTED]>
>Subject: Re: Get the next AUTO INCREMENT value for a column
>Date: Sun, 5 May 2002 14:06:43 -0400
>
>IMO th
n say I wouldn't really ever use it except for personal use,
> >not in an actual application.
> >
> >Harrison
> >- Original Message -
> >From: "Paul DuBois" <[EMAIL PROTECTED]>
> >To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL P
riginal Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, May 04, 2002 12:16 PM
>Subject: Re: Get the next AUTO INCREMENT value for a column
>
>
>> At 9:0
t; <[EMAIL PROTECTED]>
To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 04, 2002 12:16 PM
Subject: Re: Get the next AUTO INCREMENT value for a column
> At 9:01 -0700 5/4/02, Son Nguyen wrote:
> > CREATE table test1 (ID int NOT
* Son Nguyen
> CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
> text, Primary Key (ID));
>
> INSERT into test1 (name, value) values ("test1", "value1");
>
> INSERT into test1 (name, value) values ("test2", "value2");
>
> DELETE from test1 where ID=2;
>
> How can obt
At 9:01 -0700 5/4/02, Son Nguyen wrote:
> CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
>text, Primary Key (ID));
>
> INSERT into test1 (name, value) values ("test1", "value1");
>
> INSERT into test1 (name, value) values ("test2", "value2");
>
> DELETE from test1 whe