What's the syntax error in this simple mysql query ? : create table table1(date DATE PRIMARY KEY, open float(10,6), high float(10,6), low float(10,6), close float(10,6), volume INT(10), adj_close float(10,6);