MySQL Changing the type of a primary key column


Example

ALTER TABLE fish_data.fish DROP PRIMARY KEY;
ALTER TABLE fish_data.fish MODIFY COLUMN fish_id DECIMAL(20,0) NOT NULL PRIMARY KEY;

An attempt to modify the type of this column without first dropping the primary key would result in an error.