File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes multiple primary key exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "multiple primary key exception" Watch "multiple primary key exception" New topic

multiple primary key exception

niya nair

Joined: Sep 19, 2007
Posts: 11
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.

[ November 19, 2007: Message edited by: niya nair ]
Edvins Reisons
Ranch Hand

Joined: Dec 11, 2006
Posts: 364
Your CREATE TABLE statement does execute in MySQL, and it creates a table.
I agree. Here's the link:
subject: multiple primary key exception
It's not a secret anymore!