***BOGO*** How to ensure column expression gets stored as Double and not Decimal

[mos <mos99@xxxxxxxxxxx>]

I'm creating a MyISAM table using a Select statement as in:

create table t2 select if(col1>col2,1.2,4.1) NewCol from t1

(Ok, the computations are a lot more complicated than that).

For some reason the column type of NewCol is Decimal and not Double. How do 
I force the expression column to be double? I have about a dozen columns 
all set to Decimal because they are expressions and I'd rather they all be 
double.  I don't want to have to do an Alter Table after the table is 
created. Any ideas?

TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx