mysql> create table test(bla varchar(255) not null); Query OK, 0 rows affected (0.10 sec) mysql> insert into test values(1.1), (2.1), (3.1); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from test; +-------------------------------------------------------+ | bla | +-------------------------------------------------------+ | 1.100000000000000088817841970012523233890533447265625 | | 2.100000000000000088817841970012523233890533447265625 | | 3.100000000000000088817841970012523233890533447265625 | +-------------------------------------------------------+ 3 rows in set (0.00 sec)