count(*)出現錯誤 #1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1 ?
CREATE TABLE IF NOT EXISTS `TEST2` (
`ID` bigint(20) NOT NULL auto_increment,
`STAT_SRC` varchar(100) collate utf8_unicode_ci NOT NULL,
`STAT_DATE` datetime NOT NULL,
`PART_NO` varchar(100) collate utf8_unicode_ci NOT NULL,
`CUST_ID` varchar(100) collate utf8_unicode_ci NOT NULL,
`A` int(11) NOT NULL default '1',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=241075 ;
執行SQL
SELECT STAT_SRC, PART_NO, count( * )
FROM SPP_STATISTIC
WHERE STAT_DATE >= '2008-09-01'
AND STAT_DATE <= '2008-09-30 23:59:59'
GROUP BY 1 , 2
MySQL 返回錯誤:
#1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1