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?
anukool.
> -----Original Message-----
> From: tonu-mysql@stripped [mailto:tonu-mysql@stripped]
> Sent: Sunday, August 08, 1999 2:58 PM
> To: Anukool Lakhina
> Cc: win32@stripped
> Subject: Re: Adding to an already existing table
>
>
>
> > 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
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread307@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>
>
