desc user_score; -- 查看数据表 user_score 结构
alter table user_score add primary key(id,score); -- 设置双主键
alter table user_score modify id smallint auto_increment; -- 设置自增键
删除主键时应注意 对应自增键的主键无法删除 需将自增键重设
alter table user_score drop primary key;
alter table user_score modify id smallint ;
alter table user_score drop primary key; -- 删除主键