create table graphod ( symbol varchar(10), day date, open float(11,5) unsigned, high float(11,5) unsigned, low float(11,5) unsigned, close float(11,5) unsigned, volume int(10) unsigned, adjclose float(11,5) unsigned ); alter table graphod add primary key (symbol, day);