Alter Column Type
How to change a table column type in MySQLRename A Column
How to rename a table column in MySQLAlter Column Default
How to change a column's default value in MySQLAlter Column Nullable
How to change the nullable flag on a MySQL table columnCREATE INDEX examples
How to create an index on one (or many) columns in MySQL.Alter Table Add Foreign Key
Adding a foreign key (otherwise known as a relation or association) to a MySQL table means adding a 'constraint'. These basic examples assume that the column type is correct, and any existing values match existing relation IDs in the target table.Alter Table Drop Foreign Key / Constraint
Removing a foreign key (otherwise known as a relation or association) from a MySQL table. Note that after removing a relation, you might also want to remove any left over indexes.Alter Table
A MySQL example for changing, adding, and removing columns for an existing table