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
