At 2:33 PM +0100 11/19/99, Ondrej Koala Vacha wrote:
> >Description:
> auto_increment=0 works as auto_increment=1
>>How-To-Repeat:
>drop table if exists auto;
>create table auto (
> id smallint(5) unsigned NOT NULL AUTO_INCREMENT
>PRIMARY KEY,
> user char(10) NOT NULL,
> host char(10) NOT NULL
>)
>
>AUTO_INCREMENT = 0
>;
>
>insert into auto (user,host) values ('A','B');
>insert into auto (user,host) values ('A','B');
What do you expect AUTO_INCREMENT = 0 to do exactly?
You can't have a 0 in an AUTO_INCREMENT column. Inserting
0 is currently like inserting NULL, so when the initial
0 is inserted, an AUTO_INCREMENT value is inserted an you
get 1.
--
Paul DuBois, paul@stripped
