This may seem a silly question, but last night I was trying to add and edit columns in an existing table using MySQL commands and I couldn't get it to work.

I would like to know how to add a column to a table, and out of interest, I would also like to know how to edit the field name of the column.

Hope someone can help.