ERROR 1062 (23000) at line 1: Duplicate entry '1332883220' for key 'group_key'
恋喵大鲤鱼 博客专家认证 2017-07-17 11:17:12 我在insert into uinPortrait时使用select uin,sum(addCnt),sum(successCnt) from t group by uin时报的错误。我确定数据表tablename没有主键和唯一索引,请大神告诉我是什么原因报这种错误,我各种google和baidu也没有找到原因。万分感谢!
tablename的建表语句如下:
CREATE TABLE IF NOT EXISTS uinPortrait(
uin int(10) unsigned NOT NULL DEFAULT 0,
addCnt int(10) unsigned NOT NULL DEFAULT 0,
successCnt int(10) unsigned NOT NULL DEFAULT 0
)ENGINE=MyISAM DEFAULT CHARSET=utf8;