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/[EMAIL PROTECTED]
