expand a table in mysql

[Anon]

Hi,

I'm looking for the syntax to expand a table to add another field/column. Anyone that can point me in the right direction? (Couldnt find it in the mysql manual, nor on most of my common reference sites.)

Thanks,
Tim

[Anon]

alter table table_name add column_name column_type;

example:

alter table test add new_col varchar(30);