List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 25 2000 5:17am
Subject:Re: NEWBEE: AUTO_INCREMENT ?
View as plain text  
At 10:19 PM -0700 11/24/00, OTR Comm wrote:
>Hello,
>
>I ahve read the manual on auto_increment, but I can not seem to get it
>right.  I can get it to work okay if I want to start at 1, but not any
>onther number.  I want to start a table at 1070, so I have the
>following:
>
>CREATE TABLE chart (
>   id int NOT NULL AUTO_INCREMENT,
>   primary key (id),
>   accno int,
>   description text,
>   balance float,  
>   type char(1) DEFAULT 'A',
>   gifi int,
>   category char(1),
>   link text
>) AUTO_INCREMENT = 1070;
>
>This gives me errors!

It is generally more helpful to show what the error is than to say
it doesn't work.  What's the error message?

>
>Can someone please tell me what I am doing wrong here?

Perhaps you're using a version of MySQL older than 3.23?  That's when the
feature of being able to set the initial sequence value was introduced.

-- 
Paul DuBois, paul@stripped
Thread
NEWBEE: AUTO_INCREMENT ?OTR Comm25 Nov
  • Re: NEWBEE: AUTO_INCREMENT ?Paul DuBois25 Nov
  • Re: NEWBEE: AUTO_INCREMENT ?Danny25 Nov
  • Re: NEWBEE: AUTO_INCREMENT ?OTR Comm25 Nov