changing auto increment into a static field

[seanpaulcail]

What is the SQL command to change an auto increment field into a static field?

Thanks

[LordShryku]

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