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.0000 |
+-------------+
1 row in set (0.00 sec)
If i try to attach this data to Mysql 4.1.14-standard.
It is truncating the value to 9999.9999
Is there any way to solve this issue without chaning the db structure... ?
Regards,
Senthil
--
_______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.
Powered by Outblaze
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
