Re: mysql alter types..

[Roy R. <ro...@rr...>]

Jamie
This can be done with
ALTER TABLE tablename MODIFY columnname MEDIUMINT UNSIGNED
to change a column from SMALLINT to MEDIUMINT
I think this works with most all column types.
I know I have changed varchar to enum before.


Thanks and God Bless
Roy

Cash4uSafeList
http://cash4usafelist.com

----- Original Message -----
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Tuesday, July 16, 2002 7:59 PM
Subject: Re: mysql alter types..


> Shortalones del Fuego wrote:
>
> > is there any reason why the alter abilities of the mysql module don't
> > include altering the data type?
> >
> > I've come across several instances where I've needed to change a data
type
> > from say a "date" to a "datetime" type, and have had to do it manually
> > because webmin won't allow it gui style (yes, I know I can use the
> > "execute sql" area to make this change, which requires me to turn
> > on my brain and remember the ALTER syntax.)
> >
> > Just curious if the module will be expanded anytime soon..
>
>
> You can't do that in webmin because it cannot even be done with a manual
> SQL command (as a far as I know). Very few databases support changing the
> data type for existing columns, only increasing their type width.
>
>   - Jamie
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Jabber - The world's fastest growing
> real-time communications platform! Don't just IM. Build it in!
> http://www.jabber.com/osdn/xim
> -
> Forwarded by the Webmin mailing list at
web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list