RE: Adding to an already existing table

[<tonu-mysql]

> COOL! But would the ALTER command also work if I need to add another column?
> Or if I want to change the *type* of a column, say from char to int? or from
> set to enum?

   Yes, it works.

 For field adding, use the form
  ALTER TABLE foo ADD COLUMN NAME CHAR(40);
 And don't forget about indexes:
 ALTER TABLE foo ADD KEY NAME (NAME);
  (just as an example)

  Tonu