[GENERAL] Alter Table

[Kevin Holbrook]

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


************