RE: How to specify autoincrement primary key value

2005-02-18 Thread Denis Gerasimov
nt to have _one and only_ root category)? > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 2:31 PM > To: Denis Gerasimov; [EMAIL PROTECTED]; 'MySQL General List' > Subject: Re: How to specify autoincrement pr

Re: How to specify autoincrement primary key value

2005-02-10 Thread Martijn Tonies
> > > One simple question... AFAIK I can specify value for an autoincrement > > > primary key (int) when inserting a record like this: > > > > > > INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') > > > > > > But it doesn't work for id = 0. Why? > > > > > > I would like to use some primary

RE: How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
> > > > > Hello, > > > > One simple question... AFAIK I can specify value for an autoincrement > > primary key (int) when inserting a record like this: > > > > INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') > > > > But it doesn't work for id = 0. Why? > > > > I would like to use some p

Re: How to specify autoincrement primary key value

2005-02-10 Thread Alec . Cawley
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote on 10/02/2005 10:59:11: > > Hello, > > One simple question... AFAIK I can specify value for an autoincrement > primary key (int) when inserting a record like this: > > INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') > > But it doesn't work

How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
Hello, One simple question... AFAIK I can specify value for an autoincrement primary key (int) when inserting a record like this: INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') But it doesn't work for id = 0. Why? I would like to use some primary key values for special purpose, e.g.