The ALTER query is used to change the structure of a MySQL database. This list shows the syntax for the changes you are most likely to want to make:

ADD colname definition
ALTER colname SET DEFAULT value
ALTER colname DROP DEFAULT
CHANGE colname newcolname definition
DROP colname
MODIFY colname definition
RENAME newtablename