MySQL console - adding more fields to a table

Hey guys,

I do apologise if this is in the wrong place on the forum, wasn't sure where to put it.

what i would liek to know is, how can i add more fields to a table that has already been created via the MySQL console.

Cheers.

:)

You need to use ALTER. Eg

Code:

---

ALTER TABLE t2 ADD d TIMESTAMP;

---

Heres the link for ALTER in the MySQL manual
http://dev.mysql.com/doc/mysql/en/alter-table.html

oh thats how you do it.

Thanks. Much appreciated.