drop table if exists mytest; create table mytest ( id int not null auto_increment, objID char(255), RAdeg double, DECdeg double, magr double, sig_magr double, epoch int, magJ double, magH double, magKs double, primary key (id), index idx_ra (RAdeg), index idx_dec (DECdeg));