List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 27 1999 11:47am
Subject:Re: INSERT LIMITED TO 10 !!!!!
View as plain text  
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/
Thread
INSERT LIMITED TO 10 !!!!!Sandrine C.27 May
  • Re: INSERT LIMITED TO 10 !!!!!Paul DuBois27 May