RE: Adding to an already existing table - Anukool Lakhina - com.mysql.lists.win32

6 messages in com.mysql.lists.win32RE: Adding to an already existing table

From	Sent On	Attachments
Anukool Lakhina	08 Aug 1999 11:38
tonu...@spam.ee	08 Aug 1999 11:57
Anukool Lakhina	08 Aug 1999 12:04
tonu...@spam.ee	08 Aug 1999 12:06
Anukool Lakhina	08 Aug 1999 12:07
Peter WR	08 Aug 1999 16:16

Subject:	RE: Adding to an already existing table
From:	Anukool Lakhina (anuk...@cs.bu.edu)
Date:	08/08/1999 12:07:24 PM
List:	com.mysql.lists.win32

Nevermind, I figured it out. :-) THanks!!! I love this.

-----Original Message----- From: tonu...@spam.ee [mailto:tonu...@spam.ee] Sent: Sunday, August 08, 1999 2:58 PM To: Anukool Lakhina Cc: win...@lists.mysql.com 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