Re: float problem...

2005-11-08 Thread SGreen
"Senthil Kumar K" <[EMAIL PROTECTED]> wrote on 11/08/2005 08:31:28 AM: > Hi all, > > i want to upgrade Mysql 3.23 to 4.1.14-standard. > > I've a table with the following structure in Mysql 3.23. > > > + create table test ( amount double(8,4) ); > + insert into test set amount = 123456; > + my

float problem...

2005-11-08 Thread Senthil Kumar K
Hi all, i want to upgrade Mysql 3.23 to 4.1.14-standard. I've a table with the following structure in Mysql 3.23. + create table test ( amount double(8,4) ); + insert into test set amount = 123456; + mysql> select * from test; +-+ | amount | +-+ | 123456. |