List:General Discussion« Previous MessageNext Message »
From:Darin Isola Date:April 6 1999 8:51pm
Subject:RE: Alter Table Help
View as plain text  
Sorry for the basic question,  I _was_ confused by the ALTER docs.  That worked fine,
thanks.


Darin
-----Original Message-----
From: Thimble Smith [mailto:tim@stripped]
Sent: Tuesday, April 06, 1999 1:49 PM
To: Darin Isola; mysql@stripped
Subject: Re: Alter Table Help


On Tue, Apr 06, 1999 at 01:42:11PM -0700, Darin Isola wrote:
> Can someone please tell me how to alter this table so the field
> 'summary_path' will chamge to a blob.

What about the manual entry for ALTER TABLE isn't clear?  Here's
how you'd do it (assuming the table is named 'table_name'):

    ALTER TABLE table_name CHANGE summary_path summary_path BLOB;

In the most recent versions of MySQL you could use:

    ALTER TABLE table_name MODIFY summary_path BLOB;

Tim

Thread
Alter Table HelpDarin Isola6 Apr
  • Re: Alter Table HelpThimble Smith6 Apr
    • RE: Alter Table HelpDarin Isola6 Apr
      • Re: Alter Table HelpThimble Smith7 Apr