Multiple Primary Keys

Hello,

In MYSQL,my database name is customerdetails, and in that databse, table name is personelinfo. And i want to have multiple primary keys in a single table. Is it possible to do it in MySQL?

Thanx in advance..

You can only have one primary key, but you can have multiple columns in your primary key.

You can also have Unique Indexes on your table, which will work a bit like a primary key in that they will enforce unique values, and will speed up querying of those values.