Re: Alter Table Help

[Thimble Smith]

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