Hi Arun,
MYSQL allows only one primary key. This primary key can be used on multiple tables. There are many rules which should be followed such as it shouldn't be null and it can never change. Primary key assigned should be unique it cannot be matched with any other keys.
Mar 18, 2010