Altering large MySQL tables is a pain. Almost every ALTER TABLE command results in MySQL doing the following: Creation of a temporary copy of the table Doing the modification on the temporary copy ...

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 ...