[MySQL] #1062 - Duplicate entry '1' for key 'PRIMARY' Help me!
#5

Try this:
pawn Код:
CREATE TABLE IF NOT EXISTS `aracanahtarlar` (
`SiraNo`INTEGER PRIMARY KEY AUTOINCREMENT,
`AracID` int(11) NOT NULL,
`SQLID` int(11) NOT NULL,
PRIMARY KEY (`SiraNo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
And you must not set it:
pawn Код:
INSERT INTO `aracanahtarlar` (`AracID`, `SQLID`) VALUES
(1, 2014),
(1, 2013),
(1, 2015),
(1, 2012);
It will auto-increase..
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)