List:General Discussion« Previous MessageNext Message »
From:Gilles MISSONNIER Date:July 17 2008 8:37pm
Subject:how to display numbers with exponent
View as plain text  
Hello again,
I inserted "double" values, like :
mysql> insert into t (n) values ('0.54316E+11');

then I display it as :
54316000000
which is not easy to read.

Is there a way to tell Mysql to display such numbers
with exponent ?

I could not find a trick through and around
http://dev.mysql.com/doc/refman/5.0/en/precision-math-numbers.html

thanks.

_-¯-_-¯-_-¯-_-¯-_
Gilles Missonnier
IAP - gimi@stripped
01 44 32 81 36
Thread
• how to display numbers with exponentGilles MISSONNIER17 Jul