ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

If in Mysql get the message "ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key" when trying to drop a primary key, then do the following:

(let's say the table is 'your_table' and the primary key column w/ auto_increment is 'the_column'):

alter table your_table change the_column the_column int unsigned;

to remove the auto_increment, then do a:

alter table your_table drop primary key;

Thank you for reading this article ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key With URL http://x-tutorials.blogspot.com/2005/05/error-1075-42000-incorrect-table.html. Also a time to read the other articles.