Обсуждение: Alter Table

Hello,

    Anybody know any easy way to ALTER the column type of a column in an
existing table without dumping it?

    Something akin to : ALTER TABLE tableOne CHANGE fieldOne
VARCHAR(100).

    I have a limited varchar field that I want to change to TEXT.
    I am using 6.4.

    Thanks in advance,

                                                        -Kevin

>>>>> "KH" == Kevin Holbrook <kevin@templegames.com> writes:

 KH> Hello,
 KH> Anybody know any easy way to ALTER the column type of a column in an
 KH> existing table without dumping it?

 KH> Something akin to : ALTER TABLE tableOne CHANGE fieldOne
 KH> VARCHAR(100).

 KH> I have a limited varchar field that I want to change to TEXT.
 KH> I am using 6.4.

I think there is NO way to change the type of existing column :(

--
Anatoly K. Lasareff              Email:       tolik@icomm.ru