CREATE TABLE `uchome_log` (
`logid` mediumint( unsigned NOT NULL AUTO_INCREMENT,
`id` mediumint( unsigned NOT NULL DEFAULT '0',
`idtype` char(20) NOT NULL DEFAULT '',
PRIMARY KEY (`logid`)
) ENGINE=MyISAM AUTO_INCREMENT=16777217 DEFAULT CHARSET=gbk
表的下个主键值是16777217 。INSERT INTO uchome_log (`id`, `idtype`) VALUES ('1208376', 'uid')
INSERT INTO uchome_log (`logid`,`id`, `idtype`) VALUES ('16777218','1208376', 'uid');均提示:Duplicate entry '16777215' for key 'PRIMARY'什么原因?
`logid` mediumint( unsigned NOT NULL AUTO_INCREMENT,
`id` mediumint( unsigned NOT NULL DEFAULT '0',
`idtype` char(20) NOT NULL DEFAULT '',
PRIMARY KEY (`logid`)
) ENGINE=MyISAM AUTO_INCREMENT=16777217 DEFAULT CHARSET=gbk
表的下个主键值是16777217 。INSERT INTO uchome_log (`id`, `idtype`) VALUES ('1208376', 'uid')
INSERT INTO uchome_log (`logid`,`id`, `idtype`) VALUES ('16777218','1208376', 'uid');均提示:Duplicate entry '16777215' for key 'PRIMARY'什么原因?
INSERT INTO uchome_log (`logid`,`id`, `idtype`) VALUES ('','1208376', 'uid');