1、創(chuàng)建表時(shí)設(shè)置組合主鍵
CREATE TABLE sc (
sno INT,
cid INT,
score INT,
PRIMARY KEY (sno,cid)
);
2、創(chuàng)建表后設(shè)置組合主鍵
alter table sc add primary key (sno,cid);