How to modify primary key in MySQL because, I forget auto_increment field?

50 Views Asked by At
mysql> alter table users
-> modify user_id int primary key not null auto_increment;

ERROR 1068 (42000): Multiple primary key defined

0

There are 0 best solutions below