add a column

[blackdog]

is there a way to add a column to an existing table?

thanks!

[r937]

alter table foo add column bar integer

[CatsEyeDesigns]

there are lots of ways... easiest way is if you have phpMyAdmin available.

If so, select your database in the left column, then select the table you want to modify (once again, in the left column).

Then, in the right column, you'll see a section that says "add new field" with an input box to enter the number of fields you're adding.