List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 6 1999 8:49pm
Subject:Re: Alter Table Help
View as plain text  
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