List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:December 13 2009 5:11pm
Subject:Duplicate Entry, But Table Empty!
View as plain text  
Hi;

mysql> insert into tem126072414516 (ProdID, Quantity) values ("2", "2");
ERROR 1062 (23000): Duplicate entry '2' for key 2
mysql> select * from tem126072385457;
Empty set (0.00 sec)

mysql> describe tem126072385457;
+----------+-----------------+------+-----+---------+----------------+
| Field    | Type            | Null | Key | Default | Extra          |
+----------+-----------------+------+-----+---------+----------------+
| ID       | int(5) unsigned | NO   | PRI | NULL    | auto_increment |
| ProdID   | int(5) unsigned | YES  | UNI | NULL    |                |
| Quantity | int(3) unsigned | YES  |     | NULL    |                |
+----------+-----------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

Please advise.
TIA,
Victor

Thread
Duplicate Entry, But Table Empty!Victor Subervi13 Dec
  • Re: Duplicate Entry, But Table Empty!Pinter Tibor13 Dec
    • Re: Duplicate Entry, But Table Empty!Victor Subervi13 Dec
      • Re: Duplicate Entry, But Table Empty!Johan De Meersman14 Dec
      • Re: Duplicate Entry, But Table Empty!Mattia Merzi14 Dec