a newbie question

[scorpioy]

I have a table in mysql and have some rows in it. Now if I want to add one more column to the table, what I know is just to drop that table and create it again with more column in it, but I lost my previous record. Is there a statement for adding columns to the table directly? Or what do I have to do?

I also want to know how to do a backUp for table content.

Thanks.

[mrhappiness]

maybe you want to have a look at phpmyadmin?

[mourisj]

To add a column:

alter table tablename add (new_col int)

or something similar as you need.

Buy a good MySql reference to look up for details