I'm creating a table using a Select statement and several of the columns
are mathematical expressions. Unfortunately MySQL 5.0 creates them as
Decimal and I don't need that much precision. Is there a way to force MySQL
to create these columns as float?
Example:
create table x1 select 123.1*2.1 as Colx;
This creates Colx as Decimal and I'd like to have it as a Float. Is there a
way to force it to use Float?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]