List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 11 2000 12:43pm
Subject:Re: AutoNumber
View as plain text  
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
Thread
AutoNumberJoseph E. Rouillier III11 Jan
  • Re: AutoNumbermiguel angel sol√≥rzano11 Jan
  • Re: AutoNumbergw-sqladmin11 Jan
    • RE: AutoNumberJohn Zook11 Jan
    • Re: AutoNumberPaul DuBois11 Jan
  • Re: AutoNumbermiguel angel sol√≥rzano11 Jan