Re: AutoNumber

[Paul DuBois]

At 2:36 PM +0800 2000-01-11, gw-sqladmin wrote:
>do you know how to auto incrementing from a default value ie. 1000?
>
>I tried this line but doesnt work:
>
>create table member (
>    ID   int default 1000 auto_increment not null primary key,
>    ...something
>)


To specify the initial AUTO_INCREMENT value in the CREATE TABLE
statement, you must have MySQL 3.23.  See the syntax for
CREATE TABLE in chapter 7 of the MySQL Reference Manual for the
exact syntax.

-- 
Paul DuBois, paul@stripped