MySQL Cookbook

Chapter 8. Modifying Tables with ALTER TABLE

Section 8.1.  Introduction

Section 8.2.  Dropping, Adding, or Repositioning a Column

Section 8.3.  Changing a Column Definition or Name

Section 8.4.  The Effect of ALTER TABLE on Null and Default Value Attributes

Section 8.5.  Changing a Column's Default Value

Section 8.6.  Changing a Table Type

Section 8.7.  Renaming a Table

Section 8.8.  Adding or Dropping Indexes

Section 8.9.  Eliminating Duplicates by Adding an Index

Section 8.10.  Using ALTER TABLE to Normalize a Table