· 7 years ago · Sep 13, 2018, 03:44 PM
1Getting a duplicate key error in MYSQL. No duplicate found
2DROP TABLE IF EXISTS `CatalogueBasket`;
3CREATE TABLE `CatalogueBasket` (
4 `ID` int(11) NOT NULL auto_increment,
5 `Shopper` char(35) NOT NULL default '',
6 `ItemLink` int(11) NOT NULL default '0',
7 `Quantity` int(11) NOT NULL default '0',
8 `Created` datetime NOT NULL default '0000-00-00 00:00:00',
9 `ExpectedDelivery1` datetime default NULL,
10 `ExpectedDelivery2` datetime default NULL,
11 `Comments` char(255) default NULL,
12 `Status` int(10) unsigned default NULL,
13 `QuantityShipped` int(10) unsigned default NULL,
14 `HarmonyNumber` int(10) unsigned default NULL,
15 `StartDate` datetime default NULL,
16 KEY `ID` (`ID`),
17 KEY `Shopper` (`Shopper`),
18 KEY `ItemLink` (`ItemLink`),
19 KEY `Quantity` (`Quantity`),
20 KEY `Created` (`Created`)
21) TYPE=MyISAM;
22
23Duplicate entry '116604' for key 1
24
25INSERT INTO CatalogueBasket (Shopper,ItemLink,Quantity,Created, Status, StartDate)
26VALUES ('0.80916300 1338507348',58825,1,'2012-06-01 09:58:23', 0, '0-0-0')
27
28SELECT * FROM `CatalogueBasket` order by ID desc limit 1