首先要删除原有的约束和主键,然后用sql语句设置: 表qxs的三个字段dim1,dim2,dim3设置为主键 ALTER TABLE qxs ADD CONSTRAINT yueshu PRIMARY KEY (dim1,dim2,dim3)