At 10:19 PM -0700 11/24/00, OTR Comm wrote:
>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
>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