Changing storage engine; rebuild table; change file_per_table, ALTER COLUMN OF TABLE, Change auto-increment value, Renaming a MySQL table, ALTER table add INDEX, Changing the type of a primary key ...

mysql_prepare_alter_table () : Prepare column and key definitions for CREATE TABLE in ALTER TABLE. lists of columns and keys to add, drop or modify into, essentially, CREATE TABLE definition - a list ...