While creating table in mysql I've set wrong name to primary key column.

```
ALTER TABLE `table_name` CHANGE COLUMN `old_id_name` `new_id_name` integer auto_increment primary key

```

After that I'm getting

```
Error message: Multiple primary key defined

```

So the question is how can I rename the column. Note that I don't want to change primary key to another but just rename it.