Run: ruby alter_table.rb table_name 'modifications' e.g. ruby alter_table.rb my_table 'add new_column integer, add index (column_name)' Take a look at the generated files and follow instructions; TODO ...

If renaming a temporary table, the ALTER TABLE version of the syntax must be used.. Steps: Replace <old name> and <new name> in the line above with the relevant values.Note: If the table is being ...

If MySQL exits in the middle of an in-place ALTER TABLE operation (ALGORITHM=INPLACE), you may be left with an orphan intermediate table that takes up space on your system. This section describes how ...