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 ]
posted 8 years ago
Your CREATE TABLE statement does execute in MySQL, and it creates a table.