Re: Adding to an already existing table - Peter WR - 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:	Peter WR (pw...@post4.tele.dk)
Date:	08/08/1999 04:16:32 PM
List:	com.mysql.lists.win32

Hi,

You can try http://www.calistra.com/mySQL/ where You can download a GUI interface for maintenance of MySQL databases.

Best regards Peter

Hello all,

I'm a beginner and I've printed and browsed thru the 400+ page manual.

Here's my problem. I can create tables no problem. However, if tomorrow, I 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 suppose I need to add more columns in addition to those that already exist - is this stuff pretty easy to do in mySQL with no loss of data? How would I go about doing this?

Thanks!

anukool.