Composed PRIMARY key

[Admin]

Here is how to define a composed primary key in MySQL:

Código:


ALTER TABLE table_name ADD PRIMARY KEY(idcol1, idcol2);


and if the table has already a primary key:

Código:


ALTER TABLE table_name DROP PRIMARY KEY, ADD PRIMARY KEY(idcol1, idcol2);