can i make 2 columns primary key

[seco]

Hi

can i make 2 columns primary key in mysql? or i have to make it using php code by searching?

 

thanks in advance.

 

[aschk]

Yes, now would you like to know how?

in a table creation statement:

CREATE TABLE mytable (
col1 INT UNSIGNED NOT NULL,
col2 INT UNSIGNED NOT NULL,
PRIMARY KEY (col1,col2)
)

or after table creation

ALTER TABLE mytable ADD PRIMARY KEY (col1,col2)