At 7:48 AM +0000 5/27/1999, Sandrine C. wrote:
>Hello !
>I have a little problem
>When I insert tuples in the table organisme, evrythg goes fine... until I
>want to insert teh 11th one !!!
>here is the error message he gives me !
>
>CAN YOU SEE WHAT S WRONG??
>mysql> select * from organisme;
>+---------+--------------+--------------------+------------+-----------+-------
>-
>-----------+--------------+----------------+------------+------------+
>| OR_Code | OR_Raison | OR_Libelle | AD_Adresse | OR_Statut |
>OR_Impl
>ementation | CO_Directeur | CO_InterlPrinc | OR_Etat | OR_DateMAJ |
>+---------+--------------+--------------------+------------+-----------+-------
>-
>-----------+--------------+----------------+------------+------------+
>| 1 | CAFAL | Caisse d Alloc | 22 | Public |
>Locale
> | 1 | 1 | En Attente | 1994-02-04 |
>| 2 | CRCI | Chambre de Comm... | 11 | Public |
>Regiona
>le | 2 | 2 | Actif | 0000-00-00 |
>| 3 | xxtttyyuii | lalatt | 3 | Public |
>Regiona
>le | | | Actif | 0000-00-00 |
>| 4 | aa | | 4 | |
> | | | Actif | 0000-00-00 |
>| 5 | aazz | | 5 | |
> | | | Actif | 0000-00-00 |
>| 6 | aazzee | | 6 | |
> | | | Actif | 0000-00-00 |
>| 7 | aazzeerr | | 7 | |
> | | | Actif | 0000-00-00 |
>| 8 | aazzeerrqq | | 8 | |
> | | | Actif | 0000-00-00 |
>| 9 | aazzeerrqqss | | 9 | |
> | | | Actif | 0000-00-00 |
>| 10 | ggggg | | 10 | |
> | | | Actif | 0000-00-00 |
>+---------+--------------+--------------------+------------+-----------+-------
>-
>-----------+--------------+----------------+------------+------------+
>10 rows in set (0.00 sec)
>
>mysql> insert into organisme values(
> -> NULL,'TTTTT','','','','','','','','');
>ERROR 1062: Duplicate entry '10' for key 1
>
>
>And here is the descrition of my table :
># ** ORGANISME ** : OK
>CREATE TABLE organisme (
> OR_Code VARCHAR(8) PRIMARY KEY AUTO_INCREMENT NOT
>NULL,
> OR_Raison VARCHAR(40) UNIQUE NOT NULL,
> OR_Libelle VARCHAR(50),
> AD_Adresse VARCHAR(8),
> OR_Statut ENUM('', 'Prive', 'Public'),
> OR_Implementation ENUM('', 'Nationale', 'Regionale',
>'Locale'),
> CO_Directeur VARCHAR(8),
> CO_InterlPrinc VARCHAR(8),
> OR_Etat ENUM ('Actif', 'Inactif', 'En Attente') NOT
>NULL,
> OR_DateMAJ DATE NOT NULL,
> INDEX OR_index (OR_Code, OR_Etat, OR_Raison, OR_DateMAJ) );
AUTO_INCREMENT fields are supposed to be integers, not strings.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
