Is it possible to retrieve non-exponential value in double
data type column? After the width of the column is increased to 15 it shows the values in exponential form.
Now I get the following:
mysql> create table abc(a int,b double) engine innodb;
mysql> insert into abcd values(10,123456789123456789123456789);
mysql> select * from abc;
+------+-----------------------+
| a | b |
+------+-----------------------+
| 10 | 1.2345678912345679e26 |
+------+-----------------------+
Instead of this I want it to be shown in the form what I entered as 123456789123456789123456789
on mysql client.