DROP TABLE IF EXISTS t1; CREATE TABLE t1(a int); INSERT INTO t1 VALUES (1), (2); <?xml version="1.0"?> <mysqldump> <database name="test"> <table name="t1"> <row> <field name="a">1</field> </row> <row> <field name="a">2</field> </row> </table> </database> </mysqldump> DROP TABLE t1; CREATE TABLE t1 (a decimal(240, 20)); INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"), ("0987654321098765432109876543210987654321"); -- MySQL dump 9.09 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 4.0.17-debug-log -- -- Table structure for table `t1` -- CREATE TABLE t1 ( a decimal(240,20) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `t1` -- INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890.00000000000000000000"); INSERT INTO t1 VALUES ("0987654321098765432109876543210987654321.00000000000000000000"); DROP TABLE t1; CREATE TABLE t1 (a double); INSERT INTO t1 VALUES (-9e999999); -- MySQL dump 9.09 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 4.0.17-debug-log -- -- Table structure for table `t1` -- CREATE TABLE t1 ( a double default NULL ) TYPE=MyISAM; -- -- Dumping data for table `t1` -- INSERT INTO t1 VALUES (NULL); DROP TABLE t1;