Change table properties in MySQL::

The most basic one is :


ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;



More detailed can be found here:

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html