From: Krzysztof Jedon
Date: March 22 1999 4:58pm
Subject: Re: SQL!!!
List-Archive: http://lists.mysql.com/win32/34
Message-Id: <36F676D1.219E520C@wol.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Marcel Graber wrote:
> 
> alter table xyz change column xyz xyz int
> 
> marcel
> 
> At 16:35 22.03.1999 +0000, you 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
> >

Thanks all of you. It works!


jed