drop database if exists float_test; create database float_test; use float_test; create table numbers ( id INT NOT NULL AUTO_INCREMENT, float_val FLOAT, double_val DOUBLE, PRIMARY KEY (id) ) ENGINE=MyISAM;