Turning primary key off

[BenjaminMichael]

In MySQL
How do I keep a field that is a primary key, but change the field so it is not a primary key any more?

[LordShryku]

http://www.mysql.com/doc/en/ALTER_TABLE.html

[BenjaminMichael]

Why not just

DROP PRIMARY KEY <column>

less words and easier for me to under stand.

I do appreciate the help though.

[LordShryku]

You'll learn more from looking at the manual