Is it possible to create a table in MYSQL where more then one fields can be defined as Primary key ?

Question

Is it possible to connect database with c code, if yes then how?

If possible share the sample code for connecting to a MySQL database and run a sample query....

Answer 1

I hope I understood your question correctly -
1) One table can not have more then one primary key.

create table User(
   name  TEXT  NOT NULL , 
   email  TEXT  NOT NULL ,
   PRIMARY KEY (email)
);

2) Its possible to have one primary key and rest as keys (unique key).

create table User(
   name  TEXT  NOT NULL , 
   email  TEXT  NOT NULL ,
   PRIMARY KEY (email),
   KEY (email)
);

3) Its also possible to have a combination of two column as a single primary key where individual value can be repeated in the same table but not the combination

create table User(
   name  TEXT  NOT NULL , 
   email  TEXT  NOT NULL ,
   PRIMARY KEY (name, email)
);

Answer 2

Hi...

In MySql there is not possible to two primary key in same table. but you can use multiple unique key in same table.

example:

create table User(
   name  TEXT  NOT NULL , 
   email  TEXT  NOT NULL ,
   PRIMARY KEY (email)
);