Re: [GENERAL] How to alter the size of a column

[Chris Bitmead]

Michael Talbot-Wilson wrote:
> 
> >      I want to alter the size of a column, say from char(40) to char(80),
> > but it seem that
> > the  ALTER does not support such operation, nor does it support column
> > removing.
> >
> >      How can I do for this ?
> 
> I would also like to know how to do both of these things.

I'm not aware of an easy way of doing it. But you can dump your schema
and data separately. Manually edit your schema. Reload the schema then
reload the data.