First of all remove AI (auto increment) on the cols and then: ALTER TABLE name_table DROP PRIMARY KEY;