Re: Adding to an already existing table

[<tonu-mysql]

> need to add another field to the *same* table, or modify a field, or rename
> a field, do I need to recreate the entire table and move my data across? (By
> field, I mean a column). How would I go about doing this? Say I have a
> column of type int and we decide later that this should really be floator


   For example, you made a field NAME CHAR(40) and want to change it to
SURNAME CHAR(40):

  ALTER TABLE foo CHANGE COLUMN NAME SURNAME CHAR(40);

  That's all!

   Tonu