ErrorCode:1068.Multipleprimarykeydefined

ErrorCode:1068.Multipleprimarykeydefined

1、錯誤描述

10:10:38	alter table user add num int(8) primary key first	Error Code: 1068. Multiple primary key defined	0.000 sec

這個錯誤的原因是定義了兩個主鍵，導致出錯

3、解決辦法

alter table user add num int(8) primary key first;

去掉“primary key”