From: Michael Stearne
Date: March 22 1999 4:36pm
Subject: Re: SQL!!!
List-Archive: http://lists.mysql.com/win32/35
Message-Id: <36F67190.5A02F5C2@eisolutions.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

You can use the ALTER table statement.  Check the manual for more info.

Michael

Krzysztof Jedon wrote:

> I have only one SQL question.
> How can I change the type of one column
> in an existing table without much work with it... :-)
>
> An example:
> change a type of one column from smallint
> in mediumint.
>
> Any advice? Thanks for your help.
>
> jed
>
> ---------------------------------------------------------------------
> To request this thread, e-mail win32-thread33@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: win32-help@stripped