Remove Primary Key in MySQL
Without an index, maintaining an autoincrement column becomes too expensive, that’s why MySQL requires an autoincrement column to be a leftmost part of an index. You should remove the autoincrement property before dropping the key: Note that you have a composite PRIMARY KEY which covers all three columns and id is not guaranteed to be … Read more