Re: How to ensure column expression gets stored as Double and not Decimal

In the last episode (Jun 27), mos said: > 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

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

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 d