Informatics Practices (MySQL)

Is it possible for a table to have more than 1 Primary key at the same table?

no
  • 0
No i guesa
  • -2
yes it is if you write it as primary key(column1,column2);
if you write it two times for 2 diff columns then it will give you an error
 
  • 0
Primary key is unique. It is defined by the programmer while making the table for unique identification of each row. However candidate key are combination of columns which may serve as primary key.
  • 0
no
 
  • 0
yes you can create two primary keys by initially not mentioning abt them but say you want two primary keys id and sno ,you should type at the last primary key(id,int)
  • -1
No, it's not possible to have more than one primary key for a table.
  • 0
What are you looking for?