Can I change the data type of a column in a table from varchar(10) to
smallint(5) unsigned zerofill. The column that is set to varchar(10) is
populated with values from a primary key column in another table that has a
datatype smallint(5) unsigned zerofill and I need to make them both the
same. I
Mark,
Thursday, September 19, 2002, 12:24:45 PM, you wrote:
MC Can I change the data type of a column in a table from varchar(10) to
MC smallint(5) unsigned zerofill. The column that is set to varchar(10) is
MC populated with values from a primary key column in another table that has a
MC
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?
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
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