Re: problem with CREATE TEMPORY TABLE SELECT <math expression>

I found the solution to my problem:

ROUND() does the trick, it will create the correct column type

CREATE TEMPORARY TABLE T1
SELECT
    ...,
    ROUND( < math expression>, n ) AS proba


HTH someone.
Ignatius

<keyword: MySQL>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10644@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.