Thread: 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