1、创建表时设置组合主键
CREATE TABLE sc (
sno INT,
cid INT,
score INT,
PRIMARY KEY (sno,cid)
);
2、创建表后设置组合主键
alter table sc add primary key (sno,cid);