posted 17 years ago
hai all
i am getting an exception like
MySQLSyntaxErrorException multiple primary key defined.
my query is
CREATE TABLE `first_item` (
`itemid` int(5) unsigned NOT NULL default '0',
`subitemid` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`,`subitemid`)
)
i am using innodb as the database engine.
can someone give me any suggestion please.
thanks
[ November 19, 2007: Message edited by: niya nair ]