Bagaimana dengan ini?
mysql> create table test1 (num double(30,8));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test1(num) values(9876543210000123.12345);
Query OK, 1 row affected (0.00 sec)
mysql> insert into test1(num) values(9.87654321000012312345E+15);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test1;
+---------------------------+
| num |
+---------------------------+
| 9876543210000124.00000000 |
| 9876543210000124.00000000 |
+---------------------------+
2 rows in set (0.02 sec)
==============================================================
mysql> create table test1 (num double(30,5));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test1(num) values(9.8765E+55);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test1;
+----------------------------------------------------------------+
| num |
+----------------------------------------------------------------+
| 98764999999999999894059666036130517206454827827471581184.00000 |
+----------------------------------------------------------------+
1 row in set (0.00 sec)
--
amal
--------------------------------------------------------------------------------
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
