Re: Changing datatypes on the fly?

2002-03-11 Thread BD
At 02:59 PM 3/9/2002, you wrote: I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and inserting data from the old one to it?

Changing datatypes on the fly?

2002-03-09 Thread Jarkko Toivonen
I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and inserting data from the old one to it? -Jarkko

Re: Changing datatypes on the fly?

2002-03-09 Thread Jeremy Zawodny
On Sat, Mar 09, 2002 at 10:59:52PM +0200, Jarkko Toivonen wrote: I have a column defined as varchar(255) in my MySql-database. Now I realized that there's not enough room for my inserts. Is there any chance to change it's datatype to tinytext without making an entirely new database and