如:将表table_name的add_pkey字段改为主键
先删除所有主键
Alter table [table_name] drop primary key;
再添加主键
Alter table [table_name] add primary key(`pkey1`, `pkey2`,`add_pkey`);
如:将表table_name的add_pkey字段改为主键
先删除所有主键
Alter table [table_name] drop primary key;
再添加主键
Alter table [table_name] add primary key(`pkey1`, `pkey2`,`add_pkey`);