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 , 2MySQL 返回錯誤:
#1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1
`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 , 2MySQL 返回錯誤:
#1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1
实际查询中的名字是SPP_STATISTIC
怎么搞?
但是执行同一条sql时都会出现这个错误。
SELECT STAT_SRC, PART_NO, count( * )
FROM test2
WHERE STAT_DATE >= '2008-09-01'
AND STAT_DATE <= '2008-09-30 23:59:59'
GROUP BY 1 , 2