SQL Adding a Column to an Existing Table

Since I can never remember the syntax to add a column to a table, here it is:

alter table foo_tablename add column foo_column int(10) default null

alter table – the actual command
foo_tablename – the table name we’re altering
add column – telling sql to add a column instead of some other alteration
foo_column – name of the column to add
int(10) default null – the column’s qualities (it’s an int up to 10 digits long, can be null and defaults to null