Mysql command

[toyin64]

I want to add to extra columns to an existing table in the database. What is the command or for doing it. Thanks

[DR_LaRRY_PEpPeR]

ALTER TABLE table ADD column_name create_definition [FIRST | AFTER other_column_name]

the optional FIRST or AFTER other_column is if you want the new column in a certain "place." by default, the new column will be added to the end of the table.

reference: www.mysql.com/doc/A/L/ALTER_TABLE.html