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
