RE: How to specify autoincrement primary key value

2005-02-18 Thread Denis Gerasimov
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 primary key value One simple question

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,

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 for id = 0.

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 primary key values for

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 key values for special