Posted by Andy Jeffries on 06/14/31 11:33

On Thu, 01 Dec 2005 14:43:54 -0600, Khai wrote:
> As I suspected, but what about the removal of any fields? Will that
> maintain the data in the other fields, or does it destroy the whole table?

ALTER TABLE foo DROP bar;

Will only drop the bar column on foo table, leaving all other columns and
tables intact.

Likewise:

ALTER TABLE foo ADD bartext VARCHAR(255);

Will add the column bartext and leave all other columns and tables intact.

Cheers,


Andy


--
Andy Jeffries | gPHPEdit Lead Developer
http://www.gphpedit.org | PHP editor for Gnome 2
http://www.andyjeffries.co.uk | Personal site and photos

• Next in forum: how to connect to a remote computer?
• Prev in forum: Re: getting ID field (autoinc)
• Thread view: Re: Can you add/remove fields..

[Reply to this message]