OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Auto Increment Problem

From: Victor Subervi (victorsubervigmail.com)
Date: Sat Dec 05 2009 - 12:23:40 CST

Oops. Never mind.
V

On Sat, Dec 5, 2009 at 1:19 PM, Victor Subervi <victorsubervigmail.com>wrote:

> Hi;
>
> mysql> insert into categories (Category, Parent) values ('test', NULL);
> ERROR 1062 (23000): Duplicate entry '0' for key 1
> mysql> describe categories;
> +----------+-----------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------+-----------------+------+-----+---------+-------+
> | ID | int(3) unsigned | NO | PRI | NULL | |
> | Category | varchar(40) | YES | | NULL | |
> | Parent | varchar(40) | YES | | NULL | |
> +----------+-----------------+------+-----+---------+-------+
> 3 rows in set (0.00 sec)
>
> Why the error?
> TIA,
> Victor
>